Forum Discussion
Can you search for multiple things at the same time
Each day I receive a list of about 50 unique 6 digit numbers on a spreadsheet. I then have to check each of these numbers individually on a second separate spreadsheet to avoid duplication of work. ...
Let's say the unique values are on a sheet named Unique in A2:A51.
The long list is on another sheet in A2:A1001.
In another cell on that sheet, enter the formula
=FILTER(A2:A1001, ISNUMBER(XMATCH(A2:A1001, Unique!A2:A51)), "- no matches -")
This will return the matching values (if any).
See the attached demo workbook.