Gord,
Dave's linkie no-workie for me ... it's odd. clicking on the link in his
post brings up a Page Not Found notice. But typing the address as displayed
directly into my browser brings it right up. Perhaps Moh couldn't get there
either??

JLatham
"Gord Dibben" wrote:

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