Spreadsheet: 114384d1310132049-is-it-possible-to-use-a-cell-reference-that-refers-to-the-name-of-a-named-range-indirectexample
Sheet: Sheet4

Sheet11.1.1_ | =Sheet1!$A$2:INDEX(Sheet1!$A:$A,[NAME])
Sheet11.1.2_ | =Sheet1!$B$2:INDEX(Sheet1!$B:$B,Sheet1lrow)
Sheet11.1.3 | =Sheet1!$C$2:INDEX(Sheet1!$C:$C,Sheet1lrow)
Sheet11.2.4_ | =Sheet1!$D$2:INDEX(Sheet1!$D:$D,Sheet1lrow)
Sheet11.2.5_ | =Sheet1!$E$2:INDEX(Sheet1!$E:$E,Sheet1lrow)
Sheet11.2.6 | =[NAME]:INDEX(Sheet1!$F:$F,Sheet1lrow)
Sheet11.3.1_ | =Sheet1!$G$2:INDEX(Sheet1!$G:$G,[NAME])
[NAME] | =Sheet1!$DT$2:INDEX(Sheet1!$DT:$DT,[NAME])
Sheet111.1.4_ | =Sheet1!$DU$2:INDEX(Sheet1!$DU:$DU,[NAME])
Sheet111.1.5_ | =Sheet1!$DV$2:INDEX(Sheet1!$DV:$DV,Sheet1lrow)
Sheet111.1.6 | =Sheet1!$DW$2:INDEX(Sheet1!$DW:$DW,[NAME])
[NAME]_ | =Sheet1!$DX$2:INDEX(Sheet1!$DX:$DX,[NAME])
Sheet112.2.1_ | =Sheet1!$DY$2:INDEX(Sheet1!$DY:$DY,Sheet1lrow)
Sheet112.2.2_ | =Sheet1!$DZ$2:INDEX(Sheet1!$DZ:$DZ,Sheet1lrow)
Sheet112.2.3_ | =Sheet1!$EA$2:INDEX(Sheet1!$EA:$EA,Sheet1lrow)
Sheet112.2.4_ | =Sheet1!$EB$2:INDEX(Sheet1!$EB:$EB,Sheet1lrow)
Sheet112.3.1_ | =[NAME]:INDEX(Sheet1!$EC:$EC,Sheet1lrow)
Sheet12.1.1_ | =Sheet1!$H$2:INDEX(Sheet1!$H:$H,[NAME])
Sheet12.1.2_ | =Sheet1!$I$2:INDEX(Sheet1!$I:$I,[NAME])
Sheet13.1.1_ | =Sheet1!$J$2:INDEX(Sheet1!$J:$J,Sheet1lrow)
Sheet13.1.2_ | =Sheet1!$K$2:INDEX(Sheet1!$K:$K,Sheet1lrow)
Sheet13.1.3_ | =Sheet1!$L$2:INDEX(Sheet1!$L:$L,[NAME])
Sheet13.1.4_ | =Sheet1!$M$2:INDEX(Sheet1!$M:$M,Sheet1lrow)
Sheet13.1.5_ | =Sheet1!$N$2:INDEX(Sheet1!$N:$N,Sheet1lrow)
Sheet14.1.1_ | =Sheet1!$O$2:INDEX(Sheet1!$O:$O,[NAME])
Sheet14.2.1_ | =Sheet1!$P$2:INDEX(Sheet1!$P:$P,[NAME])
Sheet14.2.2_ | =Sheet1!$Q$2:INDEX(Sheet1!$Q:$Q,Sheet1lrow)
Sheet14.3.2_ | =Sheet1!$R$2:INDEX(Sheet1!$R:$R,Sheet1lrow)
Sheet14.3.3_ | =Sheet1!$S$2:INDEX(Sheet1!$S:$S,Sheet1lrow)
Sheet14.3.4_ | =Sheet1!$T$2:INDEX(Sheet1!$T:$T,Sheet1lrow)
Sheet14.3.5_ | =Sheet1!$U$2:INDEX(Sheet1!$U:$U,Sheet1lrow)
Sheet14.3.6_ | =Sheet1!$V$2:INDEX(Sheet1!$V:$V,Sheet1lrow)
Sheet14.3.7_ | =Sheet1!$W$2:INDEX(Sheet1!$W:$W,[NAME])
Sheet14.3.8_ | =Sheet1!$X$2:INDEX(Sheet1!$X:$X,Sheet1lrow)
Sheet14.3.9_ | =Sheet1!$Y$2:INDEX(Sheet1!$Y:$Y,[NAME])
Sheet15.1.1_ | =Sheet1!$Z$2:INDEX(Sheet1!$Z:$Z,Sheet1lrow)
Sheet15.2.1_ | =Sheet1!$AA$2:INDEX(Sheet1!$AA:$AA,Sheet1lrow)
Sheet15.2.2_ | =[NAME]:INDEX(Sheet1!$AB:$AB,Sheet1lrow)
Sheet15.3.1_ | =[NAME]:INDEX(Sheet1!$AC:$AC,Sheet1lrow)
Sheet15.3.2_ | =Sheet1!$AD$2:INDEX(Sheet1!$AD:$AD,Sheet1lrow)
Sheet16.1.1_ | =Sheet1!$AE$2:INDEX(Sheet1!$AE:$AE,[NAME])
Sheet16.1.2_ | =Sheet1!$AF$2:INDEX(Sheet1!$AF:$AF,Sheet1lrow)
Sheet16.1.3_ | =Sheet1!$AG$2:INDEX(Sheet1!$AG:$AG,[NAME])
Sheet16.1.4_ | =Sheet1!$AH$2:INDEX(Sheet1!$AH:$AH,Sheet1lrow)
Sheet16.1.5_ | =Sheet1!$AI$2:INDEX(Sheet1!$AI:$AI,Sheet1lrow)
Sheet16.1.6_ | =Sheet1!$AJ$2:INDEX(Sheet1!$AJ:$AJ,[NAME])
Sheet16.1.7_ | =Sheet1!$AK$2:INDEX(Sheet1!$AK:$AK,Sheet1lrow)
[NAME]_ | =Sheet1!$BR$2:INDEX(Sheet1!$BR:$BR,[NAME])
Sheet16.11.1_ | =Sheet1!$BS$2:INDEX(Sheet1!$BS:$BS,[NAME])
Sheet16.2.1_ | =Sheet1!$AL$2:INDEX(Sheet1!$AL:$AL,Sheet1lrow)
Sheet16.2.3_ | =Sheet1!$AM$2:INDEX(Sheet1!$AM:$AM,[NAME])
Sheet16.2.4_ | =Sheet1!$AN$2:INDEX(Sheet1!$AN:$AN,Sheet1lrow)
Sheet16.2.5_ | =Sheet1!$AO$2:INDEX(Sheet1!$AO:$AO,Sheet1lrow)
Sheet16.2.6_ | =Sheet1!$AP$2:INDEX(Sheet1!$AP:$AP,[NAME])
Sheet16.2.7_ | =Sheet1!$AQ$2:INDEX(Sheet1!$AQ:$AQ,Sheet1lrow)
Sheet16.3.1_ | =Sheet1!$AR$2:INDEX(Sheet1!$AR:$AR,Sheet1lrow)
Sheet16.4.1_ | =Sheet1!$AS$2:INDEX(Sheet1!$AS:$AS,Sheet1lrow)
Sheet16.5.1_ | =Sheet1!$AT$2:INDEX(Sheet1!$AT:$AT,[NAME])
Sheet16.5.10_ | =Sheet1!$BA$2:INDEX(Sheet1!$BA:$BA,Sheet1lrow)
Sheet16.5.11_ | =Sheet1!$BB$2:INDEX(Sheet1!$BB:$BB,Sheet1lrow)
Sheet16.5.12_ | =Sheet1!$BC$2:INDEX(Sheet1!$BC:$BC,Sheet1lrow)
Sheet16.5.13 | =Sheet1!$BD$2:INDEX(Sheet1!$BD:$BD,Sheet1lrow)
Sheet16.5.2_ | =Sheet1!$AU$2:INDEX(Sheet1!$AU:$AU,Sheet1lrow)
Sheet16.5.3_ | =Sheet1!$AV$2:INDEX(Sheet1!$AV:$AV,Sheet1lrow)
Sheet16.5.4_ | =Sheet1!$AW$2:INDEX(Sheet1!$AW:$AW,Sheet1lrow)
Sheet16.5.5_ | =Sheet1!$AX$2:INDEX(Sheet1!$AX:$AX,Sheet1lrow)
Sheet16.5.8_ | =Sheet1!$AY$2:INDEX(Sheet1!$AY:$AY,[NAME])
Sheet16.5.9_ | =Sheet1!$AZ$2:INDEX(Sheet1!$AZ:$AZ,[NAME])
Sheet16.6.1_ | =Sheet1!$BE$2:INDEX(Sheet1!$BE:$BE,Sheet1lrow)
Sheet16.6.10 | =[NAME],[NAME])
[NAME] | =[NAME]:INDEX(Sheet1!$BF:$BF,Sheet1lrow)
Sheet16.6.3_ | =Sheet1!$BG$2:INDEX(Sheet1!$BG:$BG,Sheet1lrow)
Sheet16.6.4_ | =Sheet1!$BH$2:INDEX(Sheet1!$BH:$BH,Sheet1lrow)
Sheet16.6.6_ | =Sheet1!$BI$2:INDEX(Sheet1!$BI:$BI,[NAME])
Sheet16.6.7_ | =Sheet1!$BJ$2:[NAME],[NAME])
Sheet16.6.8_ | =Sheet1!$BK$2:INDEX(Sheet1!$BK:$BK,[NAME])
Sheet16.6.9_ | =Sheet1!$BL$2:INDEX(Sheet1!$BL:$BL,Sheet1lrow)
Sheet16.7.1_ | =Sheet1!$BN$2:INDEX(Sheet1!$BN:$BN,[NAME])
Sheet16.8.1_ | =Sheet1!$BO$2:INDEX(Sheet1!$BO:$BO,Sheet1lrow)
Sheet16.9.2_ | =Sheet1!$BP$2:INDEX(Sheet1!$BP:$BP,[NAME])
Sheet16.9.3_ | =Sheet1!$BQ$2:INDEX(Sheet1!$BQ:$BQ,Sheet1lrow)
Sheet17.1.1_ | =Sheet1!$BT$2:INDEX(Sheet1!$BT:$BT,Sheet1lrow)
Sheet17.1.3_ | =Sheet1!$BU$2:INDEX(Sheet1!$BU:$BU,Sheet1lrow)
Sheet17.1.4_ | =Sheet1!$BV$2:INDEX(Sheet1!$BV:$BV,Sheet1lrow)
Sheet17.2.1_ | =Sheet1!$BW$2:INDEX(Sheet1!$BW:$BW,Sheet1lrow)
Sheet17.2.2_ | =Sheet1!$BX$2:INDEX(Sheet1!$BX:$BX,[NAME])
Sheet17.2.3_ | =Sheet1!$BY$2:INDEX(Sheet1!$BY:$BY,[NAME])
Sheet17.3.1_ | =Sheet1!$BZ$2:INDEX(Sheet1!$BZ:$BZ,[NAME])
Sheet17.3.2_ | =Sheet1!$CA$2:INDEX(Sheet1!$CA:$CA,Sheet1lrow)
Sheet17.3.3_ | =Sheet1!$CB$2:INDEX(Sheet1!$CB:$CB,[NAME])
Sheet17.3.4_ | =Sheet1!$CC$2:INDEX(Sheet1!$CC:$CC,Sheet1lrow)
Sheet17.4.1_ | =Sheet1!$CD$2:INDEX(Sheet1!$CD:$CD,Sheet1lrow)
Sheet17.5.1_ | =Sheet1!$CE$2:INDEX(Sheet1!$CE:$CE,Sheet1lrow)
Sheet17.5.10 | =Sheet1!$CN$2:INDEX(Sheet1!$CN:$CN,Sheet1lrow)
[NAME] | =Sheet1!$CO$2:INDEX(Sheet1!$CO:$CO,[NAME])
Sheet17.5.12 | =Sheet1!$CP$2:INDEX(Sheet1!$CP:$CP,Sheet1lrow)
Sheet17.5.13 | =Sheet1!$CQ$2:INDEX(Sheet1!$CQ:$CQ,Sheet1lrow)
Sheet17.5.14 | =Sheet1!$CR$2:INDEX(Sheet1!$CR:$CR,[NAME])
Sheet17.5.15 | =Sheet1!$CS$2:INDEX(Sheet1!$CS:$CS,[NAME])
[NAME] | =Sheet1!$CT$2:INDEX(Sheet1!$CT:$CT,[NAME])
Sheet17.5.17 | =Sheet1!$CU$2:INDEX(Sheet1!$CU:$CU,[NAME])
Sheet17.5.18 | =Sheet1!$CV$2:INDEX(Sheet1!$CV:$CV,Sheet1lrow)
Sheet17.5.19 | =Sheet1!$CW$2:INDEX(Sheet1!$CW:$CW,[NAME])
Sheet17.5.2_ | =Sheet1!$CF$2:INDEX(Sheet1!$CF:$CF,Sheet1lrow)
Sheet17.5.3_ | =Sheet1!$CG$2:INDEX(Sheet1!$CG:$CG,[NAME])
Sheet17.5.4_ | =Sheet1!$CH$2:INDEX(Sheet1!$CH:$CH,[NAME])
Sheet17.5.5_ | =Sheet1!$CI$2:INDEX(Sheet1!$CI:$CI,Sheet1lrow)
Sheet17.5.6_ | =Sheet1!$CJ$2:INDEX(Sheet1!$CJ:$CJ,[NAME])
Sheet17.5.7_ | =Sheet1!$CK$2:INDEX(Sheet1!$CK:$CK,Sheet1lrow)
Sheet17.5.8 | =Sheet1!$CL$2:INDEX(Sheet1!$CL:$CL,Sheet1lrow)
Sheet17.5.9 | =[NAME]:INDEX(Sheet1!$CM:$CM,Sheet1lrow)
Sheet17.6.1_ | =Sheet1!$CX$2:INDEX(Sheet1!$CX:$CX,[NAME])
Sheet17.6.2_ | =Sheet1!$CY$2:INDEX(Sheet1!$CY:$CY,Sheet1lrow)
Sheet17.6.3_ | =Sheet1!$CZ$2:INDEX(Sheet1!$CZ:$CZ,Sheet1lrow)
Sheet17.7.1_ | =Sheet1!$DA$2:INDEX(Sheet1!$DA:$DA,Sheet1lrow)
Sheet17.7.2_ | =Sheet1!$DB$2:INDEX(Sheet1!$DB:$DB,[NAME])
Sheet17.7.3_ | =Sheet1!$DC$2:INDEX(Sheet1!$DC:$DC,Sheet1lrow)
Sheet17.7.5_ | =Sheet1!$DD$2:INDEX(Sheet1!$DD:$DD,Sheet1lrow)
Sheet17.8.1_ | =Sheet1!$DE$2:INDEX(Sheet1!$DE:$DE,Sheet1lrow)
Sheet17.9.1_ | =Sheet1!$DF$2:INDEX(Sheet1!$DF:$DF,[NAME])
Sheet19.1.1_ | =Sheet1!$DG$2:INDEX(Sheet1!$DG:$DG,Sheet1lrow)
Sheet19.2.1_ | =Sheet1!$DH$2:INDEX(Sheet1!$DH:$DH,Sheet1lrow)
Sheet19.2.2_ | =Sheet1!$DI$2:INDEX(Sheet1!$DI:$DI,Sheet1lrow)
Sheet19.2.3_ | =Sheet1!$DJ$2:INDEX(Sheet1!$DJ:$DJ,Sheet1lrow)
Sheet19.2.4_ | =Sheet1!$DK$2:INDEX(Sheet1!$DK:$DK,Sheet1lrow)
Sheet19.2.5_ | =Sheet1!$DL$2:INDEX(Sheet1!$DL:$DL,Sheet1lrow)
Sheet19.2.6_ | =Sheet1!$DM$2:INDEX(Sheet1!$DM:$DM,Sheet1lrow)
Sheet19.2.7_ | =Sheet1!$DN$2:INDEX(Sheet1!$DN:$DN,Sheet1lrow)
Sheet19.3.1_ | =Sheet1!$DO$2:INDEX(Sheet1!$DO:$DO,Sheet1lrow)
Sheet19.3.2_ | =Sheet1!$DP$2:INDEX(Sheet1!$DP:$DP,[NAME])
Sheet19.3.3_ | =Sheet1!$DQ$2:INDEX(Sheet1!$DQ:$DQ,Sheet1lrow)
Sheet19.3.4_ | =Sheet1!$DR$2:INDEX(Sheet1!$DR:$DR,Sheet1lrow)
Sheet19.4.1_ | =Sheet1!$DS$2:INDEX(Sheet1!$DS:$DS,[NAME])
Sheet1lcol | =COUNTA(Sheet1!$1:$1)
Sheet1lrow | =COUNTA(Sheet1!$A:$A)
Sheet1myData | =Sheet1!$A$1:INDEX(Sheet1!$1:$65536,Sheet1lrow,Sheet1lcol)