Excel 2013 Formula - maybe IF formula?

Solved/Closed
Cookie5 Posts 3 Registration date Friday March 20, 2015 Status Member Last seen April 2, 2015 - Mar 20, 2015 at 10:18 AM
 Cookie5 - Mar 23, 2015 at 09:05 AM
I have a list of names in Excel and I need to put their supervisor name in the cell to the right of each name. I would like to find a formula that will automatically check each name and depending on that name put their supervisor name in the cell to the right. There are duplicates in the name list. Is this possible?

What I have so far is: =IF(A1:A19="John","Deb") I have been copying the formula down the list and it puts Deb by all the John names - but I would have to keep changing the formula for each name and supervisor name and copy it into each cell over and over - that doesn't seem very efficient to me.

Any help you can give me would really be appreciated. Thank you.
Related:

1 response

MaxStart Posts 339 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Mar 21, 2015 at 10:19 PM
=IF(A1:A19="Jone","Dep",IF(A1:A19="Max","Suzan",IF(A1:A19="Ada","Bryan","")))


--
Damn it !!!, is it ever gonna be the way I want it to be?
1
Thanks MaxStart! This will work and I really really appreciate you taking the time to work it out for me :-)
0