Match function multiple items
 

Hello, I have a formula working where I am looking for a Match of one
item...I would like to add 2 more items that need to match. Is there a way
to add multiple criteria to the match function? Currently I have Match(C1,
F1:H1,0) I now want to add another match citeria e.g. Match(C1andC5,?????)
I don't know how to complete. Thanks again.

Deeds,

You can return a number by using:

=SUMPRODUCT((F1:H1=C1)*(Next Range=C5)*OtherRange)

You can return a string by using:

=INDEX(RANGE(SUMPRODUCT((F1:H1=C1)*(Next Range=C5)*(ROW(F1:H1:))))

Beyond that, you need to better explain your desired results.

--
HTH,
Bernie
MS Excel MVP


"Deeds" wrote in message
...
Hello, I have a formula working where I am looking for a Match of one
item...I would like to add 2 more items that need to match. Is there a way
to add multiple criteria to the match function? Currently I have Match(C1,
F1:H1,0) I now want to add another match citeria e.g. Match(C1andC5,?????)
I don't know how to complete. Thanks again.

=MATCH(C1&C5,F1:F10&G1:G10,0)

which is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"Deeds" wrote in message
...
Hello, I have a formula working where I am looking for a Match of one
item...I would like to add 2 more items that need to match. Is there a
way
to add multiple criteria to the match function? Currently I have
Match(C1,
F1:H1,0) I now want to add another match citeria e.g.
Match(C1andC5,?????)
I don't know how to complete. Thanks again.

Thanks, however...I need the Match formula to look like the following:
Match(c1&C5,(sheet5!C1:E1 & Sheet6!C5:E5) This is not working.
I need it to look for the matches through a row (C1:E1&C5:E5)...I hope this
helps.....let me know if you need more....Thanks again.

"Bob Phillips" wrote:

=MATCH(C1&C5,F1:F10&G1:G10,0)

which is an array formula, so commit with Ctrl-Shift-Enter.

--
HTH

Bob Phillips

"Deeds" wrote in message
...
Hello, I have a formula working where I am looking for a Match of one
item...I would like to add 2 more items that need to match. Is there a
way
to add multiple criteria to the match function? Currently I have
Match(C1,
F1:H1,0) I now want to add another match citeria e.g.
Match(C1andC5,?????)
I don't know how to complete. Thanks again.