So I have a range of cells AA7:AA58 has the following index formulas.
ETC...
Is there an easier way for say indexing or some other nested formula to accomplish this without having a 5 mile long set of if statements???
PHP:
Cell - AA7: =IF(AE7=0,"",IF($AA$5=1,Jan!$C4,IF($AA$5=2,Feb!$C4,IF($AA$5=3,Mar!$C4,IF($AA$5=4,Apr!$C4,IF($AA$5=5,May!$C4,IF($AA$5=6,Jun!$C4,IF($AA$5=7,Jul!$C4,IF($AA$5=8,Aug!$C4,IF($AA$5=9,Sep!$C4,IF($AA$5=10,Oct!$C4,IF($AA$5=11,Nov!$C4,IF($AA$5=12,Dec!$C4)))))))))))))
Cell - AA8: =IF(AE8=0,"",IF($AA$5=1,Jan!$C5,IF($AA$5=2,Feb!$C5,IF($AA$5=3,Mar!$C5,IF($AA$5=4,Apr!$C5,IF($AA$5=5,May!$C5,IF($AA$5=6,Jun!$C5,IF($AA$5=7,Jul!$C5,IF($AA$5=8,Aug!$C5,IF($AA$5=9,Sep!$C5,IF($AA$5=10,Oct!$C5,IF($AA$5=11,Nov!$C5,IF($AA$5=12,Dec!$C5)))))))))))))
Cell - AA9: =IF(AE9=0,"",IF($AA$5=1,Jan!$C6,IF($AA$5=2,Feb!$C6,IF($AA$5=3,Mar!$C6,IF($AA$5=4,Apr!$C6,IF($AA$5=5,May!$C6,IF($AA$5=6,Jun!$C6,IF($AA$5=7,Jul!$C6,IF($AA$5=8,Aug!$C6,IF($AA$5=9,Sep!$C6,IF($AA$5=10,Oct!$C6,IF($AA$5=11,Nov!$C6,IF($AA$5=12,Dec!$C6)))))))))))))
ETC...
Is there an easier way for say indexing or some other nested formula to accomplish this without having a 5 mile long set of if statements???