Hello,

I have 3 columns of data and I want to display multiple cells from column C that satsify criteria in both Column A and Column B. I have put together a formula (below) which works well but only returns one result.

=INDEX($C$2:$C$647,MATCH(1,($A$2:$A$647="criteria 1")*($B$2:$B$647="criteria 2"),0)) and confirm with ctrl+****+enter

How do I do this so it returns all the results that satisfy the required criteria?

Thank you in advance!