My INDEX (and match) array is not working. Getting #REF! error

[nmss18]

Hello,
I have an INDEX and MATCH formula that looks like this:

=INDEX('Client Rank Trends-US Equities'!$D$10:$O$5084,MATCH(D$13,'Client Rank Trends-US Equities'!$D$9:$O$9,0),MATCH($A14,'Client Rank Trends-US Equities'!$A:$A,0))

Its not working. I am getting a #REF! error.

I checked separately both my row and col match formulas and they work.

[TABLE="width: 383"]
<tbody>[TR]
[TD="colspan: 4"]MATCH(D$13,'Client Rank Trends-US Equities'!$D$9:$O$9,0)

[TABLE="width: 81"]
<tbody>[TR]
[TD][TABLE="width: 383"]
<tbody>[TR]
[TD="colspan: 4"]MATCH($A14,'Client Rank Trends-US Equities'!$A:$A,0)[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]


The problem comes when I combine them, so I realize there is a problem with my array. I am only selecting the values and not the headers. There are some cells in the array which contain no values. Could that be it?
Any assistance would be much appreciated.
Thanks,
Nathan
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[Jonmo1]

You have the Row/Columns reversed in the Index

=INDEX(Range,Row#,Col#)

You put MATCH(D$13,'Client Rank Trends-US Equities'!$D$9:$O$9,0) where the Row# should be
And MATCH($A14,'Client Rank Trends-US Equities'!$A:$A,0) where the Col# should be

Also, MATCH($A14,'Client Rank Trends-US Equities'!$A:$A,0)
should probably be
MATCH($A14,'Client Rank Trends-US Equities'!$A$10:$A$5084,0)
So it will match the rows used by the Index.

 

[nmss18]

That was it. Thanks!

 

[Jonmo1]

You're welcome.