I have my main sheet that looks like this:
The 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 Compromise
column?