Forum Discussion
Look up a name based on multiple date
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
 
=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.
=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.
