Excel 2008 : Data Validation Drop Down Lists

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

Worked great thanks. Sorry for the delay. I was working on a new excel doc and saw that I never thanked you for this solution. Thanks again.