Hi, 

I am looking for a formula to return the person’s name if they are managing a location. 

So on the below table I would like to show in Column A the following

A2 – Andrea 

A3 – Bill

A4 – No match

A5 – Dave

A6 – Elliott 

A7 – No match

Example

​Hi,  I am looking for a formula to return the person’s name if they are managing a location.  So on the below table I would like to show in Column A the following A2 – Andrea A3 – BillA4 – No matchA5 – DaveA6 – Elliott A7 – No match Example    Read More

​