Created a drop down menu, now need to link selction to value in neighboring cell

[Hill_S]

Hello,

I'm fairly new to using Excel and appreciate any help offered. I started by making a list of cities in a column with their sales tax rates in the column next to it. Then I created a drop down menu on a separate worksheet where a sales person will select the city where the job is sold. What I'd like to have happen is when a city is selected from the drop down menu, the sales tax rate populates a cell on another worksheet. Seems simple enough, but I don't know how to make this work. Thanks in advance for any advice!

[Blake 7]

PLEASE SEE THE ATTACHED oppps sorry for the caps..

Please Login or Register  to view this content.

Oh - you will probably get told off by a mod due to your thread title.... so --- please read the forum rules before you get a red card!!!