Hi folks - I am building a user-friendly workbook that will enable someone to enter data based on the individual job need. One piece of this puzzle is the ability to assign a sales tax rate based on location.

Example: C1 contains a drop-down list containing several municipalities within the Phoenix metro area.

The user selects the location ie: Tempe, Mesa, etc.

Each municipality has its own tax rate, so I need to reflect that in another area of the sheet, say, Q14.

So if the user selects Mesa, I need 8.9% to show @ Q14.

I am convinced there must be a way to do this.

Thank you very much for any advice you may have.