Index returning value based on latest date

[Jamie Wagler]

Hello,

Please refer to the attached file for reference.

Using the Index(match I can get the first date by matching part# in column A to the one on the "Count History" tab to populate C Column, but in cases where the part appears more than once I need the most recent date to appear in the highlighted column.

Column D is the number of appearances each part appears in Column A of the "Count History" tab

 

[jayalaxmi]

Hello,

Please refer to the attached file for reference.

Using the Index(match I can get the first date by matching part# in column A to the one on the "Count History" tab to populate C Column, but in cases where the part appears more than once I need the most recent date to appear in the highlighted column.

Column D is the number of appearances each part appears in Column A of the "Count History" tab

 

[Jamie Wagler]

Vlookup does not return the latest date, it will only return the date of the first appearance of the part#

 

[tomas]

Hi

see in the attachement

 

[Tiago MF]

Hi

On C2:
Array Formula (needs to be confirmed with Ctrl+Shift+Enter)
=MAX(('Count History'!$A$2:$A$175=A2)*'Count History'!$B$2:$B$175)

Non-array
=SUMPRODUCT(MAX(('Count History'!$A$2:$A$175=A2)*'Count History'!$B$2:$B$175),1)

Regards

 

[Jamie Wagler]

Thank you everyone!