PDA

View Full Version : From one column to another column



doctortt
12-09-2012, 12:08 AM
Can someone help?

Cell A1: Assumptions!D18
Cell B1: Is there a way to make this formula to point to Assumptions!G18 by using the formula in Cell A1?

p45cal
12-09-2012, 02:00 AM
If cell A1 contains the text string Assumptions!D18 (ie. there is no = sign before it) then:
=OFFSET(INDIRECT(A1),0,3)

doctortt
12-09-2012, 07:56 AM
What if A1 is actually =Assumptions!D18?

p45cal
12-09-2012, 08:27 AM
As far as I'm aware, not with any built-in worksheet functions.

But what is it you need this for?