can you use the match formula to look for two different values?
 

can you use the match formula to look for two different values?
 

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)

"alpa" wrote in message
...