Index match not working

[jackpaz]

I have the following formula which is bringing back n/a but works on another section of data in the same file. I can't work out what the issue is. Could someone please help.

=INDEX(Summary!$R$558:$AF$571,MATCH(E15,Summary!$R$558:$R$571,0),MATCH(J2,Summary!$R$558:$AF$571,0)) This one doesn't work

=INDEX(Summary!$R$538:$AF$555,MATCH(E13,Summary!$R$538:$R$555,0),MATCH(J2,Summary!$R$538:$AF$538,0)) This one does work

 

[Fluff]

Hi & welcome to MrExcel.
It should be

=INDEX(Summary!$R$558:$AF$571,MATCH(E15,Summary!$R$558:$R$571,0),MATCH(J2,Summary!$R$558:$AF$558,0))

 

[jackpaz]

Aww.

=INDEX(Summary!$R$558:$AF$571,MATCH(E15,Summary!$R$558:$R$571,0),MATCH(J2,Summary!$R$558:$AF$558,0))

I missed that! Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.