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. To do this I copy one unique ID from the 1st spreadsheet and use the 'Find' function on the second spreadsheet. Doing this 50 times is quite time consuming so I was wondering if there was a way of searching all 50 at the same time. I am in no way tech/excel savvy so please any replies can they be in 'idiots guide'. Thanks everyone!
1 Reply
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.
