fareedexcel Member Apr 1, 2020 #1 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. Attachments Capture Data.xlsx 23.2 KB · Views: 6
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.
B bosco_yip Excel Ninja Apr 1, 2020 #2 Maybe, J6, copied across and down : =INDEX($C$6:$F$15,MATCH($I6&" Total",$B$6:$B$15,0),COLUMN(A$1))