I need to cross-reference two long columns with names, some of which are exact matches and some of which are partial matches, and then associate values from a third column, which are normally tied to the 2nd column, to the 1st column where matches between the names occur.
Firstly, how closely do the names need to match in order for this to work? Secondly, how do I do this? Thanks!
Solved by M. B. in 11 mins