Hello all-
I need to create a form(Fax cover sheet) that will autofill the fax number
and phone number when I type in a name. I have the data on sheet 2 that
includes the name, fax number, and phone numbers in columns A, B, and C
respectively. I have played around with a couple of different formulas, but
have not been able to come across the correct combination. Any help would
be greatly appreciated. This is a bit above my head.

Thank you,

Michael

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