using offset function

[Guest]

I am trying to use the offset function to find a value and bring over bits of
information from the table the value represents. My only problem is getting
the function to use the value inside a cell for the cell reference. ie.
=offset(B29,5,1,1,1) where cell B29's contents are
"sheet1!D263". How do I get the function to recognize the sheet1!D263
instead of the actual cell B29?

 

[T. Valko]

Try it like this:

=OFFSET(INDIRECT(B29),5,1,1,1)

 

[Guest]

thank you, it works, you are a life saver.

Try it like this:

=OFFSET(INDIRECT(B29),5,1,1,1)

 

[T. Valko]

You're welcome. Thanks for the feedback!