INDEX MATCH MATCH not working

[un1verseman]

Hi friends,

I'm trying to get the first column duplicated in a second column using the correct INDEX MATCH MATCH formula.

So for example, the below should match

1 2 3 4 5 6 7 8 9 10 11
UNITED KINGDOM B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2

But as you can see the second table, the formula is not matching the data correctly. I'm using the INDEX MATCH MATCH because I'm trying to look up both the horizontal (numbers 1 through 11) and vertical (name of country) components.

1 2 3 4 5 6 7 8 9 10 11
UNITED KINGDOM B33 C33 D33 E33 F33 G33 H33 I33 J33 K33 L33


My attempted solution

=INDEX($B$2:$L$33,MATCH($P2,$A$2:$A$33),MATCH(Q$1,$B$1:$L$1))


Any help would be appreciated to get this sample working, if I can get this to work, I can use it on a more complex data set.

[Sam Capricci]

try it with the 0 at the end... =INDEX($B$2:$L$33,MATCH($P2,$A$2:$A$33,0),MATCH(Q$1,$B$1:$L$1,0))

[etaf]

how about
=INDEX($B$2:$L$33,MATCH($P2,$A$2:$A$33,0),MATCH(Q$1,$B$1:$L$1,0))

[un1verseman]

Thank you for the help gents! much appreciated

[etaf]

you are welcome