+ Reply to Thread
Results 1 to 2 of 2

How to: Return list of values from one column based on two criteria

  1. #1
    Registered User
    Join Date
    Hangzhou, China
    MS-Off Ver

    Post How to: Return list of values from one column based on two criteria

    Hi there,

    I'm making a sheet to analyze livestream participation and want to make the document automatically list the students who are absent for a given event (chosen by drop-down menu).

    In Sheet A (see image), I have entered "Real name" of two participants. And underneath three livestream events marked them as Absent.

    In Sheet B (see image), I want the names of any absent participant for a given livestream event to appear (can be selected using the dropdown in the top left corner).

    So, using the examples in the images, if I choose Livestream event "Kick-Off", "Alibaba Story" or "PEST", I want both Andreas and Rasmus to appear as a list. And if I delete "Absent" in either of the events, the name should not appear on the list in Sheet B.

    And, if, lets say, the list got 100 names on it, I want the names of those who are absent for any of those events to appear when I choose either event.

    I'd then make a formula to say if "x real name" then (DingTalk Name, Group Name, Tutor) to fill in the rest based on the name that appears in the list.

    I have tried with Index + Match and Lookup, but I'm not really able to figure out the logic that says: "When X event is chosen -> lookup "Absent" in Y Column -> return name in 3rd column."

    Hope someone got some good ideas. I'm new to this forum, so not sure if I can upload the file if that is of any help.

    Looking forward to hearing from you - thank you very much in advance!


    Attached Images Attached Images

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    market harborough, england
    MS-Off Ver
    Excel 2010

    Re: How to: Return list of values from one column based on two criteria

    Big yellow banner - how to upload sample file.
    HelpUs to HelpYou

+ 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. Replies: 2
    Last Post: 04-24-2019, 06:25 AM
  2. Replies: 3
    Last Post: 05-12-2018, 05:07 PM
  3. Replies: 6
    Last Post: 05-11-2018, 03:55 AM
  4. [SOLVED] VBA Creating a list of unique values from one column based on criteria from another column
    By bilbo85 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-09-2016, 02:38 PM
  5. Return 3 values from column based on random value but with exlusion criteria
    By anxiolydiot in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-29-2015, 07:32 AM
  6. Return a list of cell values based on criteria in other columns
    By Mikeyd74 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-16-2015, 10:02 AM
  7. Return column values based on criteria
    By SalientAnimal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-11-2014, 10:55 AM


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