Excel -- need to lookup values for "in between" numbers

Experts:

Based on an organization's revenue stream, I need some assistance with looking up values from a tax table (in Excel).

Please see attached XLS for more details...

Basically though, I enter a revenue stream value in cell G17.   Then, cells G20 and G21 will give me the corresponding values from the table.

Any ideas which formulae I can use to accomplish that?

Thanks,
EEH
Between.xlsx
ExpExchHelpAsked:
Who is Participating?
 
CompProbSolvCommented:
See attached

I changed G20, G21, and added B23:G:24

Also, unless I misunderstood, I think your G21 was incorrect ($13,500 instead of $13,750)
BetweenEdited.xlsx
0
 
ExpExchHelpAuthor Commented:
CompProbSolv -- perfect solution!!!!  

Thank you so much for your prompt assistance!

EEH
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.