Kelly
New member
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