Forum Discussion
Solved
Filter a list based on another list
I have a list of SKUs as text strings in one worksheet. I have another worksheet with rows of transactions that use Item Names that contain the SKU strings plus other text. I want to filter the rows...
Let's say the SKUs are in A2:A200 on a sheet named SKU List, and the transactions in A2 and down on a sheet named Transactions.
In B2 on the Transactions sheet, enter the formula
=ISNUMBER(XMATCH(1, SEARCH('SKU List'!$A$2:$A$200, A2)))
Fill down.
You can now easily filter the transactions on TRUE in column B.
Let's say the SKUs are in A2:A200 on a sheet named SKU List, and the transactions in A2 and down on a sheet named Transactions.
In B2 on the Transactions sheet, enter the formula
=ISNUMBER(XMATCH(1, SEARCH('SKU List'!$A$2:$A$200, A2)))
Fill down.
You can now easily filter the transactions on TRUE in column B.
Thank you.