Match function multiple items

[Deeds]

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.

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Bob Phillips]

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

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

--
HTH

Bob Phillips

"Deeds" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>