Roderick_E
Well-known Member
- Joined
- Oct 13, 2007
- Messages
- 2,051
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
How can I make it work if ANY of the criteria are matched:
(formula shows 3 criteria, can be 2 or more) -- Thanks
Code:
=INDEX(RESULT RNG,MATCH(1,INDEX((1[SUP]st[/SUP] criteria=match range)*(2[SUP]nd[/SUP] criteria=match range)*(3[SUP]rd[/SUP] criteria=match range),0,1),0))