Hi all,
I'm trying to create a cell reference that will modify the reference in another cell, not that cell itself. I've attached a picture of a super-simplified version of what I'm working on.
There's a data table below, and cells B6-B10 reference the first column of the data table. In cell C6, I'd like to have a formula that says 'One column over from the reference in B6,' which in this case would return C13. I've been playing around with an offset, but of course, that returns 'one column over from B6' itself.
Any help would be appreciated!
I'm trying to create a cell reference that will modify the reference in another cell, not that cell itself. I've attached a picture of a super-simplified version of what I'm working on.
There's a data table below, and cells B6-B10 reference the first column of the data table. In cell C6, I'd like to have a formula that says 'One column over from the reference in B6,' which in this case would return C13. I've been playing around with an offset, but of course, that returns 'one column over from B6' itself.
Any help would be appreciated!