What if

W

Wayne

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.
 
P

Paul B

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
 
G

GaryE

Wayne:

I am not 100% sure if I understand you correctly.

Having said that I think the following will work if I am understandin
you correctly.

Cell A1 contains: Name
Cell A2 contains: =if(A1="name","SSN","")
Cell A3 contains: =if(A1="name","Address","")
Cell A4 contains: =if(A1="name","e-mail address","")


Try entering this into the cells I indicated and see if you get th
result you expect.

If you do get the results you expect and you need an explanation o
what is happening in the formulas I wrote post a reply and let m
know.

If you do not get the results you expected please provide some mor
detail indicating what you are attempting. Then I (and or others) ca
try to help.


Hope this Helps,

Gary
 
Top