Return and aggregate values if it meets one or more criteria

[purlo]

I am using INDEX and AGGGATE formula, I would like to ask, is it possible to add OR function to the criteria, so that it would INDEX all values even if it meet only one criteria.
Thanks for the help

[Bo_Ry]

Please try at E2
=IFNA(INDEX($I$2:$I$5,MATCH(1,MMULT(--($B2:$D2=$J$2:$J$5),{1;1;1})/ISNA(MATCH($I$2:$I$5,$D2:D2,)),)),"")

[purlo]

Thanks a lot, it works very well. I just have one question: how can I add additional MATCH criteria on this formula? For example that $I$2:$I$5 <> I2

[JeteMc]

It may be easier to say how to add $I$2:$I$5 <> I2 if we could know what you want the results to look like after that criteria has been added.
That said the following produces some results: =IFNA(INDEX($I$2:$I$5,MATCH(1,MMULT(--($B2:$D2=$J$2:$J$5),{1;1;1})/ISNA(MATCH($I$2:$I$5,$D2:D2,))/($I$2:$I$5<>I2),)),"")
Let us know if you have any questions.

[purlo]

Thank you, thats what i needed.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.