Column L is a list of unique values that are pulled from column H and column I are the dates that go with the drivers in column H. I need the cell L2, L3, L4 ect to look up the driver in that cell in the column H and return the corresponding value from column L.

index match works great except some of the drivers are listed more than once in column H and it pulls the first date it finds which is not the most current termination date