+ Reply to Thread
Results 1 to 5 of 5

Return True or False based on two criteria

  1. #1
    Registered User
    Join Date
    10-18-2018
    Location
    Sheffield, England
    MS-Off Ver
    365
    Posts
    2

    Question Return True or False based on two criteria

    I'm trying to return True or False for every instance of a value based on two criteria.

    The data I'm working with is the result of an experiment that asked people to identify particular words as they heard someone talking. I have data for each listener and the words they identified in two columns, as in the following image:

    Example 2.jpg

    I'd like now to create a sheet that populates, for each word, and each listener, whether or not they responded to the word or not, as in the image below.

    Example.jpg

    I've tried using INDEX and MATCH formulas, but can't get them to work.

    I've attached some example data in order to demonstrate what I'm trying to do.
    Attached Files Attached Files
    Last edited by Chris_Montgomery; 10-18-2018 at 08:28 AM. Reason: Solved

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,483

    Re: Return True or False based on two criteria

    In B2 copied across and down:

    =COUNTIFS(Data!$A$2:$A$18,'What I need'!$A2,Data!$B$2:$B$18,'What I need'!B$1)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,213

    Re: Return True or False based on two criteria

    In B2, copied across and down:

    =SUMPRODUCT((Data!$B$2:$B$18='What I need'!B$1)*(Data!$A$2:$A$18='What I need'!$A2))
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Registered User
    Join Date
    10-18-2018
    Location
    Sheffield, England
    MS-Off Ver
    365
    Posts
    2

    Re: Return True or False based on two criteria

    That's worked perfectly, thanks!

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,483

    Re: Return True or False based on two criteria

    You are welcome! Thanks for the rep.

+ 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] True or False based on multiple criteria
    By Dan_B in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2017, 07:26 AM
  2. Return True or False based on multiple timestamps
    By s474810 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-03-2016, 03:51 AM
  3. [SOLVED] TRUE/FALSE Based on multiple criteria
    By bond002 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-11-2014, 06:46 AM
  4. [SOLVED] Need to Return True / False if Specific Criteria Met Between Worksheets in Same Workbbok
    By ImHorhay in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-04-2014, 08:10 PM
  5. Return subsequent list based on true/false array
    By john. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2012, 02:23 PM
  6. Deleting rows based on True/False Criteria
    By CatherineN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2007, 02:40 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