To capture Data from Main Sheet to Answer Sheet

[fareedexcel]

Hi,

I need to capture data from a main sheet to an answer sheet where I need to capture only the totals. I tried using Index and match array formula but getting an error. Please help. I have attached sample working sheet.

 

[bosco_yip]

Maybe,

J6, copied across and down :

=INDEX($C$6:$F$15,MATCH($I6&" Total",$B$6:$B$15,0),COLUMN(A$1))

 

[fareedexcel]

Thank you very much. This helps.