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.
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
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" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks