Return a cell formula and not the cell value

[ExcellingGenius]

I'm using the offset function and I am having trouble. I'm looking for a way to return the formula from a cell rather than the value. I will explain here below

I have 3 cells a1, b1 and c6. a1 = apple, b1 = a1, c6 = offset(a1, 1, 1). This is where a1 is the reference cell. However I want to know if there is a way that i can reference directly from b1 as it is equal to a1. I thought that maybe you can get the formula from b1 (which is a1) as this would save me a lot of time.

Thanks for your help

 

[Joe4]

Welcome to the Board!

If I understand you correctly, I think this formula in C6 will do what you want:

=OFFSET(INDIRECT(B1),1,1)

Give it a try, and see if it does what you want.

 

[ExcellingGenius]

Thanks but did not work

 

[Joe4]

Thanks but did not work

It worked for me, but maybe I am not understanding your question.

The formula:
=OFFSET(A1,1,1)
will return the value from cell B2

I was under the impression that you do not want to enter the cell reference A1 into this equation.
Rather, you wanted to enter a cell reference in cell B1, and have your formula reference that instead.
When reference a range "indirectly" like that, you need to use the INDIRECT function.

If that is not what you were intending to do, please try explaining again, in more detail.