Hi,

Is there anyone can help me to solve the problem?? I need the answer from
the following table by match colum and row, there is some things worng with
the formula,any ideas??
=INDEX(E6:AT47,IF(MATCH(AG37,B6:B47,0),(MATCH(AG39 ,D6:D47,0))),IF(MATCH(AO37,E3:AT3,0),(MATCH(AO39,E 5:AT5,0))))


A A B B C C C D D D D E E
E E F F
100 200 100 200 100 200 300 100 200 300 400
100 200 300 400 100 200

F 100 1 1 2 3 5 6 8 9 10
11 3 4 6 7 9 12 4
F 200 1 3 7 3 3 6 5 6 3 7 8 1
6 3 8 4
E 100 2 4 2 7 7 8 6 8 7 2 9 2 8
6 9
E 200 3 3 3 2 2 9 8 9 2 3 10 3 9 7
E 300 5 5 4 3 3 10 9 10 3 4 11 5 3
E 400 6 6 3 4 4 11 10 11 4 3 8 8
D 100 8 8 5 3 3 3 11 3 3 12 9
D 200 9 9 6 5 5 4 3 4 9 7
D 300 10 10 8 6 6 6 4 6 3
D 400 11 11 9 8 8 7 6 8
C 100 3 3 10 9 9 9 11
C 200 4 4 11 10 10 5
C 300 6 6 3 11 3
B 100 7 7 4 3
B 200 9 9 6
A 100 12 12
A 200 4