Value with double reference...........

Hi,

Pl. help


A B C D
1 Data Jan Feb Mar
2 Bob 10 80 97
3 Eric 20 90 69
4 Alan 30 100 45
5 Carol 40 110 51
6 David 50 120 77

I want the value of Alan of Feb month (100)

m using this formula

=INDEX($B$2:$D$6,MATCH("Feb",$B$1:$D$1,0),MATCH("Alan",$A$2:$A$6,0))

but the result is 69 instead of 100


then m trying 2nd formula as

=INDEX($B$2:$D$6,MATCH("Feb"&"Alan",$B$1:$D$1&$A$2:$A$6,0)) with cntl + shift + enter

but the result is #n/a

Pl. suggest .....

The row parameter should come before the column parameter, so try it like this:

=INDEX($B$2:$D$6,MATCH("Alan",$A$2:$A$6,0),MATCH("Feb",$B$1:$D$1,0))

Hope this helps.

Pete

thank you so much now i came to know i.e.

row parameter should come before the column parameter