S sachar Member Feb 20, 2016 #1 Dear All, With reference to the attach sample file, May I know what is the wrong with formula in the worksheet column “C” is returning the “#VALUE!”. Please help me? Attachments dashboard_six_senses_2016_Offset Formula.xlsx dashboard_six_senses_2016_Offset Formula.xlsx 17.2 KB · Views: 9
Dear All, With reference to the attach sample file, May I know what is the wrong with formula in the worksheet column “C” is returning the “#VALUE!”. Please help me?
V vletm Excel Ninja Feb 20, 2016 #2 @sachar It could do this way too ... Attachments dashboard_six_senses_2016_Offset Formula.xlsx dashboard_six_senses_2016_Offset Formula.xlsx 16 KB · Views: 2
B bosco_yip Excel Ninja Feb 20, 2016 #3 Another option : =IF(B7="","",INDEX('budget(MTD)'!$E$9:$Q$21,MATCH(B7,'budget(MTD)'!B$9:B$21,0),MATCH(C$6,'budget(MTD)'!E$8:Q$8,0))) Attachments Copy of dashboard_six_senses_2016_Offset Formula.xlsx Copy of dashboard_six_senses_2016_Offset Formula.xlsx 15.7 KB · Views: 1
Another option : =IF(B7="","",INDEX('budget(MTD)'!$E$9:$Q$21,MATCH(B7,'budget(MTD)'!B$9:B$21,0),MATCH(C$6,'budget(MTD)'!E$8:Q$8,0)))
