SOLVED

Look up a name based on multiple date

Copper Contributor

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

1000068703.jpg

 

2 Replies
best response confirmed by kissbalazs86 (Copper Contributor)
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.

@OliverScheurich

 

IIt worked, thank you so much! 

1 best response

Accepted Solutions
best response confirmed by kissbalazs86 (Copper Contributor)
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.

View solution in original post