Drop Down List Question

[beb1227]

I have a form that has a section at the top were I have a section that shows a contact name in one cell...and then has the contact phone number in another cell.

then it also has a requestor name in a cell and a requestor phone number in a cell.




I wanted to create lists for both the contact names...and requestor names....followed by their phone number. so I could pull the names.

I am able to create the drop down from a range.....but I was wondering if anyone might now of a way or the formula would be used to get the corresponding phone number.

on sheet #2 I would have the table for the info to pull.

column A Column B
1 name 1 number 1
2 name 2 number 2
3 name 3 number 3


I was thinking that in the cell that the phone number would be listed....a formula could be entered that would say something along the lines of

If the (cell with contact name) = Name 1 then enter number 1


Any thoughts on how to do this formula