Look up a name based on multiple date

[kissbalazs86]

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

 

[#2 · Accepted solution]

@kissbalazs86 

=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.

[#3]

@OliverScheurich

IIt worked, thank you so much!