vendredi 27 février 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)*({"criteria5","criteria6"}=columnB);0)


enter image description here


Thank you for your feedback.


Aucun commentaire:

Enregistrer un commentaire