I have two worksheets one which has 54,000 products and another which has around 10,000 products. I have organized the 10,000 sheet as needed. The problem is the image locations for these products are only listed in the 54K worksheet. I am wanting to search worksheet 1 column B for any text that is also in worksheet 2 column F. I've tried taking the SKU from worksheet two and inserting a new column in worksheet 1 and highlighting duplicates then filtering by cell fill color. However it doesn't work as expected I am still getting 54,000 listings when really there should only be 10,000 duplicates.

Thank you in advance.

Trent