Is there any way to calculate the % difference between two strings in Excel? For example, oftentimes a customer sends us a list of items that they want us to match with items in our system based on description and item SKU #. However, matching by SKU does not always return an accurate result, especially if it is short and not unique. If there was a more efficient way of doing this than manually searching & matching, it would greatly increase the efficiency of my job.
Optimally, the function would return a number... higher the number, better the possibility of a match. To be clear, both comparison cells are defined, and both exist in the same row. This would not be a Fuzzy Lookup (already have that add-in).
Possible?