Index Match + multiple criteria + return list/range

I am trying to look things up in a table and return them with a formula, with the following requirements:

1. There are two criteria (columns) to include in the look-up
2. Need to return the list of all matches rather than a single item

I have found ways of doing these things on their own (using more complex Index Match for #1 and using the ":" operator for #2 to specify a range and return a list in the form of an array), but whenever I try to combine them it doesn't work.

I have shared an example below, where 'Table 1' is the source data and 'Our selections' are the references for looking up. Can someone please let me know a formula that can go in the mentioned cell that will return the green 'Returned list' of associated entries from the 'Interaction' column (of Table 1)?

I am running a Mac with Excel version 16.46 Thanks in advance!

https://stackoverflow.com/questions/66558229/index-match-multiple-criteria-return-list-range March 10, 2021 at 12:07PM