Hi and Thanks everyone,

I am trying to create a formula that works similar to VLOOKUP except I want the result of the last match in the column. example:

A B
FTD1-1 NO
FTD1-2 YES
FTD1-3 NO
FTD1-5 NO
FTD1-4 YES
FTD1-1 YES
FTD1-6 YES
FTD1-7 NO
FTD1-8 YES
FTD1-3 YES

When I use VLOOKUP to match "FTD1-1" in column 'A', column 'B' returns "NO". What I need returned is the "YES" in column 'B' a few rows later.

I hope that makes sense.

Thanks