See the reply from Dave Peterson.

Use a VLOOKUP formula.

Dave's link shows you how.


Gord

On Sun, 24 Sep 2006 18:03:01 -0700, Moh wrote:

gord dibben i'm still waiting for your reply...

sorry ron rosenfeld but i don't know much about excel but i can understand.

is it possible someone can do me a quick template.
for example it needs to have a dropdown list with names in there and once
the user selects a name a telephone number will appear in a cell.

which i can then edit

thank you