+ Reply to Thread
Results 1 to 4 of 4

Index Match with multiple criteria and selecting data from a large table

  1. #1
    Registered User
    Join Date
    08-26-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    70

    Unhappy Index Match with multiple criteria and selecting data from a large table

    I am looking for the value in cell B10 to return an "OK" or "N/A" value after looking it up based on the two data points entered in B8 and B9 and matching it to the table beginning in J7. I've attached an example of what I am stuck on getting it to work on....please help. Example.xlsx

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Index Match with multiple criteria and selecting data from a large table

    Put this formula into B10 : =INDEX(J7:AG39,MATCH(B9,J7:J39,0),MATCH(B8,J7:AG7,0))

    Cheers

  3. #3
    Registered User
    Join Date
    08-26-2013
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    70

    Re: Index Match with multiple criteria and selecting data from a large table

    That worked! Thank you Ursul!

  4. #4
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Index Match with multiple criteria and selecting data from a large table

    You're welcome Aquarock. Please click my "* Add Reputation" (bottom left) if you're happy .... you don't have to but it helps me when helping others in the future. All the best, cheers

+ 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. Index & Match a table of data using multiple parameters
    By monaghanmj44 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2013, 01:29 AM
  2. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 AM
  3. [SOLVED] INDEX, MATCH: multiple criteria with iterative data
    By boai in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-05-2013, 06:43 AM
  4. Index / Match / Large based on a criteria.
    By SimpleJack in forum Excel General
    Replies: 7
    Last Post: 06-20-2012, 08:04 AM
  5. Replies: 5
    Last Post: 01-05-2011, 03:13 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