Forum Discussion

Mike Howarth's avatar
Mike Howarth
Copper Contributor
May 08, 2017

Index/Match Array issue

Hi   I am trying to return a value based on multiple criteria using the index match function, but one of the criteria will need to return the latest date.   The data is as below. I want to return...
Excel Desktop
Formulas & Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 08, 2017

Mike, please try this array formula

=INDEX(B:B,MATCH(1,($K$12=A:A)*(D:D=MAX(IF(A:A=$K$12,D:D))),0),0)

 

Mike Howarth's avatar
Mike Howarth
Copper Contributor
May 08, 2017

Thanks All

 

That last one seems to work.

 

KR

Mike

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 08, 2017

    Great. I didn't explain the logic, hope it's understandable

Resources