Multiple MATCH/VLOOKUP & Comma Separated Values in a Single Cell

[makingtrails]

I have two columns of comma separated keywords which I would like to use VLOOKUP to match up based on the amount of keywords.

I have attached my spreadsheet here:

http://www.makingtrails.com/keyword-test.xlsm

So for example:

Product 1 is a HP Desktop PC - Intel Dual Core with 500HDD. It has the following keywords: computers, computer, PC, desktop, dual core, intel, 500gb hdd,

Using these keywords I should be able to match it to the category (Computers - Desktops - Intel Dual Core PC) as it has the keywords: Computers, PC, Desktops, Desktop, Dual Core, Intel

Matching 5 keywords the script should choose this over other cells with simular keywords for example: computers, pc, desktop, quad core, intel. This cell only matches 4 keywords therefore is redundant.

If this is possible then superb! help me out :D

J

 

[hippiehacker]

maybe fuzzy_vlookup will work? http://www.mrexcel.com/forum/excel-...-version-plus-explanation-28.html#post3145162

 

[makingtrails]

Thanks! I will look into that