Sorry, I've searched for this but I'm lost. I tried doing it with nested IF statements, but there are too many for excel to accept.
Basically I have two cells where a user can select options from a dropdown.
Dropdown 1: size (13 options here)
Dropdown 2: tax bracket (3 options here)
Based on their choices, I'd like excel to look up the correct tax amount from a table on another sheet. The table looks something like this:
Is there a short and simple way to do this? How would the formula look if Size 1 is cell A1, and the final cell in the sheet is D13 ($9.99)?
Any help is greatly appreciated.
Bookmarks