+ Reply to Thread
Results 1 to 4 of 4

Combination of Index, Search, Match

  1. #1
    Registered User
    Join Date
    01-12-2019
    Location
    New York
    MS-Off Ver
    1811 (office 365)
    Posts
    21

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.56 for Mac (home)
    Posts
    7,856

    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.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,090

    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. #4
    Forum Contributor
    Join Date
    03-29-2013
    Location
    lakewood, usa
    MS-Off Ver
    exce2013
    Posts
    112

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with index match combination
    By vdminh21 in forum Excel General
    Replies: 3
    Last Post: 06-08-2017, 04:58 AM
  2. [SOLVED] Index Match combination in VBA
    By Arnodekkers1995 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2017, 09:17 AM
  3. IF / INDEX-MATCH Combination
    By Joshua27 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2015, 05:29 PM
  4. Match and index function combination for search
    By atif_ar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2015, 02:05 PM
  5. Combination of IF and INDEX/MATCH
    By flandophile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 09:52 AM
  6. Replies: 1
    Last Post: 07-13-2011, 09:22 AM
  7. Index Match Combination for two variables
    By zhopa19 in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 03:07 PM

Bookmarks

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