Match function multiple items

D

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.
 
B

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.
 
B

Bob Phillips

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

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

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.
 
Top