Index Match + multiple criteria + return list/range

[gidBeat]

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

• There are two criteria (columns) to include in the look-up
• 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, 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!

 

[mabbutt]

Have a look at this post.