I have 2 sets of data coming from different sources. I need to match them together, but they have not been entered in an identical fashion.
I am trying to compare two lists of names to each other and return a value if I can find a match that is 100% or less. For example, if I can match the name in column A with one in Column C, I return the name and ID of the value in C to the matching line in column A.
I would like to do the same thing where there isn't a 100% match so I can match the two different sources to find other related lines without having to review them manually.
I would also like to show the % of relatedness if possible that the calculation to compare was able to find so I can focus on the ones that have the highest %.