Vlookup or match?

I have a spread sheet with serial numbers we shipped. I want to write a formula to tell me if these same serial numbers were received back. How do I write a vlookup or a match to return a yes or a no? I want my first sheet, FG0005-10, to contain the formula that looks into sheet 2 to return a yes if it is there, and a no if it is not. I have attached the spreadsheet. View attachment Serial Numbers.xlsx

Try:

=IF(ISNUMBER(MATCH(A2,Sheet2!$A$2:$A$166,0)),"yes","no")

copied down.

Thank you, that works.