Forum Discussion
INDEX/MATCH using 2 criteria, and returning Nth value of INDEX/MATCH with 2 criteria
Hello, I have a table in which people are assigned an amount of time to a task (in this case, teaching a course). The first table is organized by person; their name repeat in column A, with cour...
Here's an altogether different way to do this, using the newly available Dynamic Array functions UNIQUE and FILTER.
The cell with the yellow background invites you to select the name of a course. Then the cells to the right will populate with the names of the staff members assigned. This happens automatically, and the only formulas are in cells G12 and H12. The results "spill" down to accommodate however many names meet the FILTER criteria.
Here's a YouTube video that explains the functions more fully.
https://www.youtube.com/watch?v=9I9DtFOVPIg