Excel Gods,

Here's the problem. I have two worksheets one labeled sales and one contacts. On the contacts sheet in Column A I have a list of names and in Column B is their phone number.

On the sales sheet I created a data validation drop down list of the names in Column B. What I want to happen is when I select a name from the drop down list on the sales sheet I want the corresponding telephone number to show in Column C.

Thanks in advance,
Excel Amateur
Philip