Wayne, sounds like vlookup will do what you want, have a look in help or
here for more information

http://www.contextures.com/xlFunctions02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Wayne" wrote in message
...
I would like to have cells put data in if another cell has a certain name
appear. Example Nmae appears in cell A1 I want cell A2 insert SSN, Cell A3
Address,cell A4 e-mail address. Please let me know what you can find.