software

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.

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

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 amp; 2003

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