Forum Discussion
Solved
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 ...
=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.
