I have a sheet with a list of about 10,000 part numbers (call this list A) I need to search each of these part numbers in list A to see if they appear on any of the sheets in a separate workbook (call this workbook B). The only catch is that workbook B contains about 20 different sheets with the matching part numbers being in all different columns and rows. Is there a formula I can use to search for each of the part numbers in list A in all of the cells on all of the sheets of workbook B and if they are found to return back the phrase "Yes"??
Bookmarks