Forum Discussion
Solved
More than 64 Nested Levels - Need to Simplify if Possible
I am attempting to create a formula that will pull from 124 lines of data so that when I type a number in, the corresponding information from the next 4 columns is pulled automatically. I got it to w...
=INDIRECT(ADDRESS($C$7,COLUMN(B1),,,"Sheet3"))You can enter this formula in cell D7 and fill it across range D7:H7.
=INDIRECT(ADDRESS($C$7,COLUMN(B1),,,"Sheet3"))You can enter this formula in cell D7 and fill it across range D7:H7.