Excel Match with multiple criteria

[loris314]

Hello,

I'm trying to use ActiveX in order to search in an Excel sheet. It is working fine with a single criteria : =MATCH(criteria, Range, 0), but with 2 criteria I don't find how to do.

I would either do =MATCH(criteria1&criteria2, range1&range2, 0) or =MATCH(1, (range1=criteria1)*(range2=criteria2), 0) but without success...

Thanks,

Regards