SOLVED

# Filter a list based on another list

Copper Contributor

# 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 of transactions against the list SKUs in the one worksheet.

Example: SKU "BG HG:TL123" Transaction row Item Name "BG HG:TL123 Fuzzy Dice"

I want to filter and find all transactions that have Item Names that contain a SKU from the list in the one worksheet.

2 Replies
best response confirmed by bracurrie (Copper Contributor)
Solution

# Re: Filter a list based on another list

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.

# Re: Filter a list based on another list

Thank you.
1 best response

Accepted Solutions
best response confirmed by bracurrie (Copper Contributor)
Solution

# Re: Filter a list based on another list

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.