D deb45 New Member Jun 4, 2018 #1 Hi, Sample file is inside. Pls answer my queries. Regards Deb Attachments SampleC.xlsx 10.9 KB · Views: 5
B bosco_yip Excel Ninja Jun 4, 2018 #2 Try........... In D3, formula copied across to H3 and all copied down : =IFERROR(1/(1/(INDEX(INDEX($C$17:$G$21,,MATCH($B3,$C$16:$G$16,0)),COLUMNS($A$1:A$1))*$C3)),"") Regards Bosco Attachments SampleC(1).xlsx 13 KB · Views: 3
Try........... In D3, formula copied across to H3 and all copied down : =IFERROR(1/(1/(INDEX(INDEX($C$17:$G$21,,MATCH($B3,$C$16:$G$16,0)),COLUMNS($A$1:A$1))*$C3)),"") Regards Bosco
