Help with VLookup

[Liliana]

Hi,

I have two sheets with the common variable being "site number". I want to identify the latest date from the sheet, "Details" that matches the corresponding date for that site number for the sheet, "configurable_export". My problem is the "Details" sheet has multiple instances of the same site number.

How can I do this? I have uploaded a sample file for reference.

Thank you!

 

[PCosta87]

Hi,

Welcome to the forum

Attached, highlighted in blue...

Hope this helps

 

[bosco_yip]

Another option,

In "Details" sheet H2, formula copy down :

=IF(LOOKUP(2,1/(C2:C$264=C2),G2:G$264)<>G2,"",IF(LOOKUP(2,1/(C2:C$264=C2),G2:G$264)=VLOOKUP(C2,configurable_export!$A$2:$D$59,4,0),"Match","Non-Match"))

Regards
Bosco

 

[Liliana]

Thank you! They both worked perfectly!

~L.

 

[PCosta87]

Don't mention it