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.
this can be tricky with formulas but it is fairly easy if you can download the fuzzy lookup Microsoft add-in here...
https://www.microsoft.com/en-us/down....aspx?id=15011
I can't tell if it will work for office 365 but if it will it is a great add-in that I've used for close matches.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
This may not work with other data
C2
=INDEX(E:E,MATCH(REPLACE(A2,FIND(" ",A2),3,"*")&"*",D:D,0))
possible in C2 =IF(LEFT(A2,5)=LEFT(D2,5),E2,0) and copy down. Might adjust the number of characters to compare.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks