+ Reply to Thread
Results 1 to 3 of 3

Meeting Multiple Conditions In A Table For Unique Output

  1. #1
    Registered User
    Join Date
    11-11-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2007
    Posts
    29

    Meeting Multiple Conditions In A Table For Unique Output

    I'm working on a algorithm whereby if a certain condition is met, I want to search a data table. In this data table, 2 conditions should prove true. If this happens, I'd like a corresponding output.

    All that sounds good in my head, but let's try visual:
    [A] [B] [C] [D]
    1] Name Pos PA Wins
    2] Dave 1b 668 7
    3] Sara c 668 5
    4] Jane rf 74 1
    5] George 1b 88 2
    6] Nefi lf 370 1

    The above represents a table of (fairly raw) data. In another part of the sheet, I have determined that Dave is the best person to play (first base) 1b. The catch is that I only know that by Column C. In other words, I understand there are 2 people to play first base and one is more effective, but I don't have the name associated yet.

    Frankly, I don't care about his/her name, either. I want to search that data table for the person with 668 PAs (found in Column C) who also plays 1b (found in Column A). I want the return to be what's found in the corresponding cell in Column D.

    I know the person has "668" PA and plays "1b" and I want the "7" Wins returned. Normally, I'd just search on who has 668 PAs, but there is no guarantee that will be a unique value. I don't think I have to separate out all the first base players to do this. That's why I'm asking here.
    Last edited by Billy Corman; 12-01-2015 at 05:14 AM.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,645

    Re: Meeting Multiple Conditions In A Table For Unique Output

    If 7 is expected :

    =LOOKUP(2,1/((B:B="1b")*(C:C=668)),D:D)
    Quang PT

  3. #3
    Registered User
    Join Date
    11-11-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2007
    Posts
    29

    Re: Meeting Multiple Conditions In A Table For Unique Output

    Nailed it. Thanks.

    Quick question, though. What is the "2,1/" after "lookup" mean?

+ 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] Help counting unique values from column meeting multiple criteria
    By Starchild in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2014, 01:25 PM
  2. [SOLVED] recognise words in multiple cells with a unique output
    By tlacloche in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-09-2014, 10:50 AM
  3. Calculating values meeting multiple conditions
    By Scardais excelforum in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-11-2014, 03:27 PM
  4. [SOLVED] using INDEX and IF to output value meeting multiple min/max range constraints
    By myersac in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-30-2013, 04:13 PM
  5. getting the min date and max date from a range after meeting multiple conditions
    By lynn.plazo@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-11-2013, 04:42 PM
  6. Replies: 8
    Last Post: 01-30-2013, 02:58 PM
  7. Frequency of unique values meeting multiple criteria
    By systemsteve in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2008, 09:50 AM

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