Identify the best match from two different column values

[girolamofalbo]

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

[binuacs]

@girolamofalbo you need to consider fuzzy match tool 

[girolamofalbo]

Sure, but my point is how to build workflow using fuzzy but considering all values present in field2 and associate best match at each row present in field 1

thanks

[girolamofalbo]

Simeone can help me with workflow example? Thanks 

[binuacs]

@girolamofalbo can you provide some sample data and expected output

[girolamofalbo]

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 

[girolamofalbo]

Someone can help? If is double ? Thanks