close
Yes
=MATCH(1,(rng1=value1)*(rng2=value2),0)
which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;alpaquot; gt; wrote in message
...
gt;
全站熱搜