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.
Patrick2788 this is good to know, unfortunately I am trying to make it so that whatever value I type in C7, that corresponding row is imported from the other sheet. I'm not totally sure if what I want to do is possible, but I got it to work with 1-64 using the formula I had. I'll keep digging around though and messing with it. Thanks!
- That's what the CHOOSEROWS formula is designed to do. Did you try the sample workbook provided?
- Yes, how are the numbers in the sample worksheet automatically referred to in the other page? When I try it in my worksheet it gives the #NAME error and won't let me use the Sheet3! command to refer to rows. Is there a way to select the data on the other sheet to be highlighted like in the example sheet?
