Trying to write a forumula based on managers from a contact list

keesuri25

I need to write an IF statement to look for "Managers" in the Team Manager column (contact list) and if they match put the corresponding region in the "Manager Region" column.

EX: IF Team Manager, is Full Name 1, Full Name 2 put US-East, else if Full Name 3, 4 US- West, etc.

IS it possible ?

Paul Newcome

Are you able to provide some screenshots for reference?

keesuri25

Manager Region - is a dropdown with values - EMEA, AMER, APJ etc

Team MANAGER - is a dropdown contact list column- First and last name.

If a manager from Team manager is AB - I want to populate Manager region column with AMER but if the manager is XY then EMEA etc. I guess a nested if statement ?

Ryan Sides

How many of these types of Manager to Region combos do you have? If it's many, it might get too cumbersome for a nested IF statement. So you might want to look at a Index/match and store your combos in another sheet.

But if you only have a few, yes the nested if statement is what you're looking for:

=IF([Team MANAGER]@row = "Jim P", "EU", IF([Team MANAGER]@row = "Bob R", "AMER", ""))

Paul Newcome

I would suggest building out a reference table with Managers in one column and the regions in another then using an INDEX/MATCH

=INDEX({Reference Sheet Region Column}, MATCH([Manager Column]@row, {Reference Sheet Manager Column}, 0))