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!
Bookmarks