I'm sure this is simple....I hope
I have two excel sheets the first sheet has a inventory list on it with serial and part number....The second sheet is a list of serials I scanned for inventory....What formula could I write so that it would look for the serial from the second sheet see if it is on the first sheet and mark a cell in the first sheet to show it was found
Thanks for the help and sorry for the rambleing
I have two excel sheets the first sheet has a inventory list on it with serial and part number....The second sheet is a list of serials I scanned for inventory....What formula could I write so that it would look for the serial from the second sheet see if it is on the first sheet and mark a cell in the first sheet to show it was found
Thanks for the help and sorry for the rambleing