+ Reply to Thread
Results 1 to 3 of 3

Formula needed for partial string match as part of index match with multiple criteria

  1. #1
    Registered User
    Join Date
    03-13-2013
    Location
    Wichita,KS
    MS-Off Ver
    365 Aps for Enterprise
    Posts
    57

    Formula needed for partial string match as part of index match with multiple criteria

    Gents,

    I have spent about 7 hours trying to insert the Left function into multiple criteria Index Match formula's that I have found on the internet but have been unsuccessful. Here is what I am attempting to do:
    Controls Pricing 201.jpg

    Here is the best I could do at putting a formula together:
    Please Login or Register  to view this content.
    Anybody out there have a solution? I have also attached my example worksheet.

    Thanks for your help!
    Marvelous (not so much)
    Attached Files Attached Files

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Formula needed for partial string match as part of index match with multiple criteria

    Some of the names you are using don't seem to exist in your sheet, so using cell references you should be able to use this "array formula"

    =INDEX(C16:H33,MATCH(1,(A16:A33=LEFT(A7,5))*(B7=B16:B33),0),MATCH(C7,C15:H15,0))

    confirmed with CTRL+SHIFT+ENTER

    ....but note that in your example the first 5 characters of A7 are AB 32 and that doesn't match any entry in A16:A33
    Audere est facere

  3. #3
    Registered User
    Join Date
    03-13-2013
    Location
    Wichita,KS
    MS-Off Ver
    365 Aps for Enterprise
    Posts
    57

    Re: Formula needed for partial string match as part of index match with multiple criteria

    daddylonglegs - Thank you so much. You are the best!

    I had to use bogus data so I did have some errors in my example data - thanks for pointing that out.

+ 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] Mutliple Index Match criteria formula needed
    By bwmuhich in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-27-2014, 03:37 PM
  2. Formula needed to sum multiple match criteria
    By bensox in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2014, 06:36 AM
  3. [SOLVED] VLOOKUP/ INDEX:MATCH part of string.
    By strud in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 12:04 PM
  4. [SOLVED] Partial String Match in COUTIF Criteria Range?
    By amazinglazers in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 09:58 AM
  5. Index Match nesting w/ partial text string criteria
    By dohearn in forum Excel General
    Replies: 1
    Last Post: 10-25-2011, 03:42 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