+ Reply to Thread
Results 1 to 3 of 3

Index Multi Match

  1. #1
    Forum Contributor
    Join Date
    07-17-2015
    Location
    Roanoke, Virginia
    MS-Off Ver
    2010
    Posts
    173

    Index Multi Match

    I am terrible at INDEX Match multiple match
    Any one help with attached
    Dashboard is where it is needed - to Data.

    Thanks for any help
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Index Multi Match

    Rather than having members searching around for what you want, where you want it, and what to base it on, you need to give FAR more details to us please.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    07-17-2015
    Location
    Roanoke, Virginia
    MS-Off Ver
    2010
    Posts
    173

    Re: Index Multi Match

    Solved with concatenation on two cells
    Array formula
    {=IFERROR(INDEX(Grid!$D$2:$L$16,MATCH($E$15&F$16,Grid!$B$2:$B$16&Grid!$C$2:$C$16,0),
    MATCH(Dash!$E17,Grid!$D$1:$L$1,0)),"")}

+ 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] INDEX MATCH multi criteria
    By 3345james in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2018, 03:59 PM
  2. New & Lost: Multi Criteria & Multi Row INDEX, SMALL, MATCH...
    By morleyp in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-23-2014, 12:40 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. Index & Match for Multi Worksheets
    By turist in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-06-2014, 09:33 PM
  5. Excel 2007 : Index, Match, or multi Vlookup
    By tlafferty in forum Excel General
    Replies: 3
    Last Post: 04-18-2012, 03:40 AM
  6. need help in sum up multi criterias (index & match)
    By aroundyou in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-17-2006, 08:25 PM
  7. need help in sum up multi criterias (index & match)
    By aroundyou in forum Excel General
    Replies: 3
    Last Post: 10-15-2006, 07:53 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