SOLVED

Look up a name based on multiple date

Copper Contributor

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

2 Replies
best response confirmed by kissbalazs86 (Copper Contributor)
Solution

Re: Look up a name based on multiple date

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

Re: Look up a name based on multiple date

@OliverScheurich

IIt worked, thank you so much!

1 best response

Accepted Solutions
best response confirmed by kissbalazs86 (Copper Contributor)
Solution

Re: Look up a name based on multiple date

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