How to reference a cell based on user input?

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.

Thank you very much! I'll give that a try now.

It works WONDERFULLY! Thank you VERY much!

I have been grinding on this issue for a couple days now. I shoulda come here first!

Glad you fixed your problem ...

Thanks for the feedback

Carim