I have my main sheet that looks like this:
Compromise column (
Column F) bases its value on another sheet. To compute its value, we check if the value of the
Basic Tax (
Column B) falls equal or between the first two columns of the reference sheet:
I can actually perform a simple
VLOOKUP() function, but how can I implement that referencing to a range instead of a singe column?
How can I derive the value for the