ExpExchHelp
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much for your prompt assistance!
EEH