May 27 2024 01:35 PM
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
May 27 2024 02:22 PM
Solution=IF(COUNTIF(OFFSET($K$1:$M$1,MATCH(B2,$J$2:$J$6,0),0),D2),B2,"No match")
This formula should work if i correctly understand what you want to do.
May 27 2024 02:34 PM
May 27 2024 02:22 PM
Solution=IF(COUNTIF(OFFSET($K$1:$M$1,MATCH(B2,$J$2:$J$6,0),0),D2),B2,"No match")
This formula should work if i correctly understand what you want to do.