finding matching data by slightly different aspects

[Nils_Junker]

Hi everybody,

just a question:
I do extract data out of different applications from our firm.
The data contains an F-Code (Material-No.) and the product description.
The problem I got, is that if a product is produced at a different plant it automatically gets another F-Code. The product description ist mostly the same but varies also sometimes.
So I just wanted to know if there is a way to always look up the right product.
(I need some other data from the product which I get via a VLOOKUP)
Following is a example:

1. F000103734; EXAMPLE PRODUCT 25 AMP
2. F000163472; EXAMPLE PRODUCT 25 AMP ENT

So same product but different F-Code and slightly different product description

Thanks for your answers!

 

[alansidman]

You could use a Fuzzy Match on the description using Power Query by joining two tables with an outer join.