If Value is > Col. A, AND < Col. B, Return Col. C

[bxyanks20]

Column A Column B Column C
50,000 52,000 5%
52,000 54,000 6%
54,000 56,000 7%

Trying to figure out the right approach/formula to say, if a value is greater than Column A AND less than Column B, return the corresponding value in Column C.

So if my value is 51,000, I'm looking to return 5%.

Should it be a combination of "IF" and "AND" functions, or maybe VLookup?

[bxyanks20]

Figured it out. Basic VLookup. Sorry, has been awhile since I've done one.

So assuming the value is in cell G5, formula should read:

=VLOOKUP(G5,$A$1:$C$3,3,TRUE)

[loginjmor]

Hi -

I would restructure your data into one column (say Column A) with your range limits:

50000
52000
52001
54000
54001
56000

And put the percentages in column B And use VLOOKUP.