Hi to all,
I have need for a specific function and I don't know if such exists already in Excel, so I'm asking you guys to help me out.
I'm using Excel 2010.
In one file I have 2 sheets.
In one sheets column A i have some data. Similar data but no completely the same are in the sheets 2 A column. Data is alphanumerical, those are names of specific spare parts with some model numbers, letters and other characters.
Is there such function that can compare data from these sheets and return best matches into third sheet, or like in the example I made in the attachment, to return the result into sheets 2 column B?
As I said data is not completely the same, but if I have lets say this: GR VM 2000W HTR005GO 587565 in sheet 1, and I have this: GR.VM.1950w ARDO/ARISTON/WHIRLPOOL KOSI ř8.1mm L195mm AR5118 HTR001UN in the other to return this as a best match or to return some other if it is better matched then this one.
Please see the attached example:
example.xlsx
Ty all in advance.
Dean
Bookmarks