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
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.
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:
- Excel 2013 Formula - maybe IF formula?
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Microsoft office 2013 free download - Download - Office suites
1 response
MaxStart
Posts
338
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
69
Mar 21, 2015 at 10:19 PM
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?
Mar 23, 2015 at 09:05 AM