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

[alpa]

[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)

"alpa" <alpa@discussions.microsoft.com> wrote in message
news:AED31D4D-5A6C-4855-A1B6-FED2AED58452@microsoft.com...
>