Forum Discussion
Non-Consecutive Cell Referencing
Hi, folks. I'm attempting to create a spreadsheet that contains links from consecutive cells to consecutive cells in another worksheet that are separated by 5 intervening cells. I'll call the origi...
MattKW1​
Option from m_tarler​ is much better - from an efficiency perspective as well. If you want to stick to INDIRECT the following addresses his point re. locked column A on the Orig sheet, the sheet name remains locked though *:
=INDIRECT( ADDRESS( QUOTIENT( ROW(B3)-ROW(B$3) +1, 5 ) +ROW(Orig!A$3), COLUMN(Orig!A3),,, "Orig" ) )* A workaround exists with Excel >/= 2013
Thank you very much for your reply. No, I wasn't hung up on INDIRECT and still don't quite understand it, but I had seen it suggested elsewhere in a similar case.
