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

B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to look up values with two independent variables 3
ranking based on criteria 1
Can I do a MAXIF similar to SUMIF and/or COUNTIF? Please Advise 0
Need to sum "last 5" red cells 7
need help in fine-tuning a formula that removes blank cells in a column range 3
sum function usin an IF statement 0
sumif only for unhidden rows 5
Index match to return all values 13

Top