Hi,

I'm trying to find a formaul that does the following;

Cell B2 is a pick-list of names. I want cell B3 to show the relevant phone
number for the name that is picked in cell B2. there will be about 31 names
to choose from in cell B2.

Any ideas?
Thanks!