Hi,

I'm sorry but this is no clearer. Your original mentioned only columns A, B & C. Now you've thrown in F Y & AA.

You need to clearly state which columns you want to compare, and then when a match is found between a value in a Sheet1 column and the same value in a Sheet2 column, which column from Sheet1 you want to pick up.

But importantly you need to manually add the results you expect to see and tell us which is the column containing the results.