So, I understand how this formula works, not requiring an array (ctrl+shift+enter) but it is an exact match formula. All criteria must match.
How can I make it work if ANY of the criteria are matched:
(formula shows 3 criteria, can be 2 or more) -- Thanks
=INDEX(RESULT RNG,MATCH(1,INDEX((1st...