Index Match Most Current Date

[boll55]

is there any formula that i can use that will provide me with the most current termination date of a specific driver

i was thinking something along the lines of

=IFERROR(INDEX(I:I,MATCH(L2,MAX(H:H,0))),"-")

this obviously doesnt work so any ideas on how to get where i need to be!?!?!?


http://www.mrexcel.com/forum/excel-q...ml#post3479321