Hello All,
I'm hoping to find some help. I've google some stuff but to no avail.
I'm looking to compare two columns and find the closes or approximate match and return a value if it finds the a close match.
I've attached an excel sheet so you can have better understanding.
If you look at the spreadsheet.. if name#1 is an approximate match to name#2, then in column C, amount#2 will appear.
Thanks a million.
Bookmarks