Index / match formula not working.

[countryfan_nt]

Hello friends, Hope all is well!

=INDEX(Sheet1!$L$5:$T$16,MATCH(C4,Sheet1!$J$5:$J$16,0),MATCH(Sheet1!D4,Sheet1!$K$5:$K$16,0),MATCH(Sheet1!E4,Sheet1!$L$4:$T$4,0))
The above formula isn't working for some reason. please help.
Thank you very much in Advance!

 

[Lian]

For muti-criteria, do not use three math, please try (eg.) this kind of fromat: match(C4&D4&E4, J5:L16 & K5:K16, 0)
You should join the criteria with "&"
Meanwhile, the range of L4:T4， should be the same dimension with J and K, better to transpose it first.

 

[Phuoc]

Try this:

=INDEX(Sheet1!$L$5:$T$16,MATCH(D4&E4,INDEX(Sheet1!$J$5:$J$16&Sheet1!$K$5:$K$16,0),0),MATCH(F4,Sheet1!$L$4:$T$4,0))

 

[AhoyNC]

It helps if you let us know what version of Excel you are using. If you have Excel 365 with the FILTER function then try:

FILTER(FILTER($L$5:$T$16,($J$5:$J$16=$C4)*($K$5:$K$16=$D4),""),$L$4:$T$4=$E4)

 

[countryfan_nt]

You were all Very helpful! I learned something new from you all.