I could click on that link or copy|paste (with the trailing space) and it opened
for me in MSIE.

But glad you got it working.

JLatham wrote:

Found the problem .... the earlier link includes a space after html making it
a link that can't be followed.

"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



--

Dave Peterson