Find last match in date sorted list using index match with multiple conditions

[RINCONPAUL]

I have this formula that works fine, but returns the first match in descending date order. I want to find the most recent match (last match) by date:

"{=INDEX(A$2:A761,MATCH(1,($B$2:$B761=$C761)*($C$2:$C761=$B761),0))}"
Cheers

[mancubus]

does this help?


=SUMPRODUCT(MAX((B2:B761=C761)*(C2:C761=B761)*(ROW(B2:B761))))

giybf

[RINCONPAUL]

does this help?


=SUMPRODUCT(MAX((B2:B761=C761)*(C2:C761=B761)*(ROW(B2:B761))))

giybf

Sorry, mate that doesn't work. No reference to the 'A' column in your formula. However with a fresh mind this morning, I was able to google up a solution:

"=LOOKUP(2,1/($B$2:$B761=$C761)/($C$2:$C761=$B761),(A$2:A761))"