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

[Bob Phillips]

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)