How many matchs can you have in an Index Match formula

[Anguscat]

I am trying to use and index match formula

=INDEX('DataTab'!C25:J59,MATCH(A20,'SummaryData'!B25:B59,0),MATCH(B16,'SummaryData'!C4:H4,0),MATCH(B15,'SummaryData'!C2:CI2,0))

I got the first part to work but then I added in a 3rd Match criteria, is this possible?

Thanks,
Bill

 

[Jonmo1]

It's not a limit of how many matches you can have...
It's the limit of how many arguments INDEX has...

Syntax is
=INDEX(Range,Row#,Col#) - 3 arguments
You have
=INDEX(Range,match1,match2,match3) - 4 arguments


I think I see what you want...Try

=INDEX('DataTab'!C25:J59,MATCH(A20,'SummaryData'!B25:B59,0),MATCH(B16&"|"&B15,'SummaryData'!C4:J4&"|"&'SummaryData'!C2:J2,0))

IMPORTANT
This is an array formula that requires CTRL + SHIFT + ENTER
After entering the formula, highlight the cell with formula and press F2
Then press CTRL + SHIFT + ENTER
When entered correctly, the formula will be enclosed in {brackets}


Hope that helps.