+ Reply to Thread
Results 1 to 5 of 5

Returning a value based on two conditions

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Returning a value based on two conditions

    Hi all,

    I am trying to return values based on two criteria. I imagine I'm looking for something similar to a VLOOKUP, but I need it to match an additional cell.

    In the attached spreadsheet I'm looking for a formula to fill H3:H11 by finding corresponding values in Q3:Q17.
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Returning a value based on two conditions

    Try this formula in H3 and copy it down

    =INDEX($Q$3:$Q$17,INDEX(MATCH(A3&B3,$O$3:$O$17&$P$3:$P$17),0),0)
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,720

    Re: Returning a value based on two conditions

    I'm not following. What are the two conditions? What should the results be? This will help to understand what you are looking for.

  4. #4
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    18

    Re: Returning a value based on two conditions

    Quote Originally Posted by AlKey View Post
    Try this formula in H3 and copy it down

    =INDEX($Q$3:$Q$17,INDEX(MATCH(A3&B3,$O$3:$O$17&$P$3:$P$17),0),0)
    Thanks! This looked like it worked.

  5. #5
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Returning a value based on two conditions

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

+ 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] Returning cell content from array based on two conditions
    By mistert in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2012, 02:19 AM
  2. [SOLVED] Returning only unique results based on multiple conditions
    By Dickens153 in forum Excel General
    Replies: 5
    Last Post: 03-29-2012, 12:29 PM
  3. Replies: 2
    Last Post: 02-01-2012, 06:28 PM
  4. returning values from columns to another sheet, based on conditions
    By zangief in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2005, 04:05 PM
  5. Returning the date based on conditions
    By itty in forum Excel General
    Replies: 1
    Last Post: 03-06-2005, 05:50 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