Identify the best match from two different column values

Question

Hi, I have two column field 1 and field2 that contains description.What is function/workflow that permit to identify what is the row/value contained in the rows of field2 that is most similar to the value contained in row 1 of the field1 and then perform the same process for the other rows of field1 and having another field that contains % of match.

Any advice would be appreciated!

Thanks

girolamofalbo · Answer

Someone can help? If is double ? Thanks

girolamofalbo · Answer

Yes, thanks

In the file attached in Sheet1 and Sheet2 there are some code with description and in the sheet3 there is the expected result. Evaluation need to be done on description and I insert a Match Value (I didn't calculate the correct match value for description that not match by 100% but I insert an approximated value .... for sure Fuzzy Tool will be more precise😀 )

Thanks again

Example for Fuzzy.xlsx

binu_acs · Answer

@girolamofalbo can you provide some sample data and expected output