Checking multiple criteria and select data over multiple columns

The match() function returrn the position in a RANGE of cells, column, row, array...
depending on how you use it, you can get both, for simple example- you want to know how many "APPLES" "JAKE" has, the information is stored in a table style..rows with name, columns with fruit(names start in A2 and go down,fruit names start in b1 and go across)...= Index($A$1:$AA$27,MATCH("JAKE",$A$2:$Z$27, 0),MATCH("APPLES",$A$1:$AA$1,0))', will give you the match of "JAKE" and "APPLES"...Say jake is in row 15, and apples is in column F,this will result in =INDEX($A$1:$AA$27,15,6), whict is the same as =$F$15, so the value at F15 gets returned...

Looks confusing I guess....

Hope this helps

the syntax for an index/match/match formula is =index(range,row,column) so in your formula, you might try to put the bolded part in a cell of its own and then reference it?

{=INDEX($D$2:$D$10,MATCH(1,(A13=$B$2:$B$10)*(B13=$C$2:$C$10),0),1)}