Hi;

with vlookup i can only get the 1st value that the formula found. in this case is only 2017.

But what formula can I use if I want to show that there are several contracts expiring for the Client in sheet2?

Ideally in sheet 1 column J I would like to see 2011, 2017, 2018 as there are multiple expiration date.
(I have added manually in sheet1 column J4 the result I would like to see with the formula)

Thanks

Attached Files

Supplier.xlsx (210.1 KB, 18 views)