If then statement for a list of individuals
I am trying to reference one cell in my spreadsheet that has a drop down list of 30+ people in the list. I want to create another cell using the if then formula to say if person a, person, c, and person h are in the first cell, provide this name for their manager. I have 4 managers that I need to divide this group into. What is the best way to write this?
Help Article Resources
Check out the Formula Handbook template!