There's a couple of ways to do this depending on your table
and the results you want. Off-hand, you can try Index..Match..

Would you provide an example and the expected result?


--


Thank You

cheers,

======================
Pls click Yes if this has help you
======================





"fats_71" wrote:

In Excel, How do I lookup a value in a list with multiple corresponding
values and return only the value with the latest date.