dimanche 1 mars 2015

Is it possible to use INDEX/MATCH (array formula) with OR ? Excel

I am not sure whether it is possible or not, but I believe the issue is worth asking. To cut it short, here is what I would like to achieve to avoid the use of a new column (group):



=MATCH(1;("B"=A:A)*(OR(criteria5=B:B ; criteria6=B:B));0)


enter image description here


Thank you for your feedback.


Aucun commentaire:

Enregistrer un commentaire