+ Reply to Thread
Results 1 to 3 of 3

Extracting a Specific Value with multipe Criteria.. (Index/Match/Hlookup/Vlookup ??)

  1. 09-25-2013, 06:56 PM #1
    buckhunt122
    buckhunt122 is offline
    Registered User
    Join Date
    06-24-2011
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    36

    Extracting a Specific Value with multipe Criteria.. (Index/Match/Hlookup/Vlookup ??)

    Hey I have actively searched with no luck.

    I need to look into a table of data and extract a specific value based on 1 criteria in row # 1 (header row) and then a criteria in Column # 1 (which has duplicate values) and then further a criteria in column # 2 which also has duplicate values. In each case between the three criteria only one cell will match. I am just struggling with the 2 column criteria.

    I know it must be some combo of Index/Match/Hlookup/Vlookup.

    Thanks in advance guys, attached is a sheet, that lays everything out perfectly.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-25-2013, 07:14 PM #2
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Extracting a Specific Value with multipe Criteria.. (Index/Match/Hlookup/Vlookup ??)

    Examplev2-1.xlsx
    Please see attached.
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  3. 09-25-2013, 07:18 PM #3
    FDibbins
    FDibbins is offline
    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,929

    Re: Extracting a Specific Value with multipe Criteria.. (Index/Match/Hlookup/Vlookup ??)

    Try this array formula...
    =INDEX($A$2:$T$11,MATCH($C$16&$B26,$A$2:$A$11&$B$2:$B$11,0),MATCH(C25,$A$2:$T$2,1))
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    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
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup with Hlookup or Index with Match?
    By brad_x81 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-08-2013, 06:40 AM
  2. Vlookup, HLookup, Index, Match, oh my! Help me.
    By ryanl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2013, 09:29 PM
  3. Vlookup/hlookup/match/index?
    By margggggg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 07:46 PM
  4. [SOLVED] Search in Table vlookup / Hlookup or INDEX - MATCH command
    By dalaie in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-13-2012, 07:42 AM
  5. [SOLVED] Vlookup & Hlookup at same time - Why is this Index+Match formula not working
    By fabrice.usa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2012, 06:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1