Forum Discussion
Cell Referencing not Autofilling Correctly
Hello, I'm having some trouble autofilling some referenced cells from another sheet. I would like to have the column letter continue its sequence but I want the row number to stay the same (ex. a11, ...
=INDEX(TPT!$11:$11,1,541+ROW(A1)-ROW($A$1))
or
=INDIRECT(ADDRESS(11,541+ROW(A1)-ROW($A$1),,,"TPT"))
These formulas return the intended result in my sample sheet if i correctly understand what you want to do.
- Thank you OliverScheurich! I tried the first formula that you listed here and it seems to work just fine. I had to adjust the 541 number to 544 but I couldn't be happier. I'm not familiar with using this type of formula so I'll research it a little bit to see what it's actually doing but in the mean time it will save me a lot of time.
