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?
Bookmarks