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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.