Forum Discussion
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...
I have no solution so far, but IMHO, both above shall not work if the maximum date in D:D (or in Table1[Date]) is out of range with searched item records. Here are nested arrays - first we have to define records with searched item (they could not be sequential in initial array), and within that range find the record with maximum date.
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)
Thanks All
That last one seems to work.
KR
Mike
Great. I didn't explain the logic, hope it's understandable
