Michael,
You need a drop downlist for your names. Take this link to find ou
how.

http://www.contextures.com/xlDataVal01.html

And then you need a VLOOKUP formula to fill in the phone and fax. T
learn how take this link.

http://www.contextures.com/xlFunctions02.html


HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=47763