Hey Everybody

Is it possible to use a formula as a reference along with the OFFSET function?

I have a simple formula:

=OFFSET(B26,-7,3)
which works fine, however I would like to include the following formula instead of B26:

=(SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")&(ROW()))
Which should return the current cell reference. So in effect this formula will be using an offset reference from the current cell.

If anyone can help with advice or a simpler way to do what I am attempting it would be greatly appreciated.