# Combination of Index, Search, Match

1. ## Combination of Index, Search, Match

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.

2. ## Re: Combination of Index, Search, Match

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.

3. ## Re: Combination of Index, Search, Match

This may not work with other data
C2
=INDEX(E:E,MATCH(REPLACE(A2,FIND(" ",A2),3,"*")&"*",D:D,0))

4. ## Re: Combination of Index, Search, Match

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

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1