Identifying Items with the most in common

[ahall351]

I'm working on a file that can automatically identify products with the most in common. For example I've tagged products with 20+ attributes(ex. Price, color, shape, etc). I want to be able to identify a comparable item based on which OTHER product has the most attribute matches.

So for example - I have the below Item in one sheet. I have a list of other products organized in the same way on another sheet. How do I return the other item that has the highest amount of attribute matches?

PLU

CLASS

SCLS

Product Type

Sub Type

Band Size

Design Style

Theme

Sub Theme

Gemstone Color

Metal

Metal Type 1

Metal Type 2

Metal Purity

Stone Shape

Stone Overall

Stone 1

Stone 2

Stone 3

Price Range

20000000​

186

0

Pendant/Necklace

Chain

Gold

White Gold

18K

Diamond

3,000 - 3,999

 

[kweaver]

Welcome.

In your single example, does this one have 10 attributes?
Then, from the other sheet you haven't shown, do you want to find other listings with 10 attributes?

It would be helpful if you showed more examples and the result you want.

 

[ahall351]

Thank you so much for responding! So the first image below is my main sheet I am working on. There are 19 "attribute" columns which may or may not have content depending on the product.

In the next image is my reference tab. This is literally just a copy of what's on my "main sheet" so I may not need this info on a separate tab but I wasn't sure.

What I want the file to do is compare the PLUs(Items) in my main sheet against the PLUs(Column A) in the reference sheet and identify which other PLU has the most attribute matches(out of the 19) and return that PLU number in the corresponding row in column AB on my main sheet.

Hopefully that makes sense. Thank you in advance for any help.