Hi All,
I am trying to index a sheet however, rows are continuously added which throws off my index. For example: I have A1 B1 C1 indexed on another sheet. However I insert a row below A1 so that B1 becomes C1, C1 becomes D1 and so on.
The formula i use is this: =INDEX('Sheet1'!A1:AB1000,1,1)
Thanks for your help.
Hi Walter,
Not sure your description is accurate. A1, B1 and C1 are all in the same row. If you insert a row below A1, cells B1, C1 and D1 are unaffected. A2, B2, C2 and D2 would shift down, though. It might help if you explain what you're trying to do with that index formula, and what result you expect. The best way to do this is upload a sample workbook showing your data layout and the results you would expect (and why).
Sorry what I meant was A1 A2 and A3 not A1 B1 and C1.
I have tried to replicate my results, but I haven't been able to. I also can't upload the workbook because it contains sensitive account information. In the simple workbook I made when I add a new row the data correspondingly changes in my index. However, when I do this on my real workbook, the data does not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks