Help on complicated array lookup

[renahearn]

Hi! I am trying to match some data. Here is an example of the data
COLUMN A COLUMN B
ROW 1 Barilla Blue Box Pasta 1674488
ROW 2 Barilla Blue Box Pasta 1675539
ROW 3 Barilla Italian Entree 1670770
ROW 4 Barilla Italian Entrees 1673317
ROW 5 Barilla Pasta Sauce 1664230
ROW 6 Barilla Whole Grain Pasta 1666211
ROW 7 Barilla Pasta 100001


ROW 10 Barilla Blue Box Pasta 1674488

Using this formula, I got the result in B:10 which is great!

=INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1)),2)


BUT sometimes lookup value may not be exactly worded as the lookup array values. i.e. it may just say Barilla Pasta, Blue Box. How do I make it run the lookup on a TRUE basis, i.e. if the values are a 50% match then I want it to return the number (167448) result to me.

Please help.....Also I would be willing to pay an expert to help me put this spreadsheet together.

Thanks!!

[XOR LX]

Hi and welcome to the forum!

Unless you want to delve into the murky realms of "fuzzy" matching, I suggest you let us know precisely what you have in mind when you say "a 50% match", preferably with several examples.

Regards

[oeldere]

Probably you could use jokersigns (e.g. * or ?)

You get better help if you add an excelfile without confidential information

[renahearn]

Anyone have experience with the Excel Fuzzy lookup add-in?