+ Reply to Thread
Results 1 to 3 of 3

Multiple Criteria - I give up and need help

  1. #1
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Question Multiple Criteria - I give up and need help

    All I have been trying to do is create a formula on tab combined file cell I2 that lookup two criteria
    1st criteria
    Combined file tab cell A2 to tab ORACLE matches column A
    2nd criteria
    Combined file tab cell B2 to tab ORACLE matches column B
    Return Criteria
    Matching ORACLE Tab column C

    I am frustrated please help.

    Combined File.xlsx

  2. #2
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Multiple Criteria - I give up and need help

    You have two choices:
    1) Create a helper column on the ORACLE tab that has A&B combined (i.e. - in D2 add the formula =A2&B2 then copy down)
    Then you can use the formula (Combined file cell I2): =INDEX(ORACLE!C:C,MATCH(A2&B2,ORACLE!D:D,0))
    2) Use a CSE formula (Combined file cell I2): {=INDEX(ORACLE!C:C,MATCH(A2&B2,CONCATENATE(ORACLE!A$1:A$305,ORACLE!B$1:B$305),0))}
    Enter the formula then press Ctrl+Shift+Enter to get the brackets (array) formula

    Option 2 takes more memory, but then you dont need to change your ORACLE tab.

  3. #3
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Multiple Criteria - I give up and need help

    I used the # 2 solution and it worked. I just don't understand enough about excel yet to understand how what i was doing wasn't working or why what you did worked either. I might try to explain what i was trying to do later but for now thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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