Almost same product name in two different column

[siyat]

Hi guys,


I am using this string =IFERROR(VLOOKUP(B:B;H:I;2;FALSE);"not found")


1 Example:

In column B I have following text: Ipad 6th Generation 32gb Space Grey

And somewhere in column H i have following text: iPad 6th gen 32GB Space Grey

And the one in column H are deviate a bit from column B, what should i do so these kind of texts can be cought?

2 Example:

In column B it says follwing product name: Huawei B525 Ca White

And in column H it says follwoing: Huawei B525
And the "CA white" part gives me the problem.

My file contains over 3000 line and I cant adjust them for every vendor manually.

Any help would be much appricieated.

 

[Gerald Higgins]

Maybe this will help . . .
https://www.mrexcel.com/forum/excel...lus-explanation.html?highlight=fuzzy+matching