Target cell by "offset" of named intersection?

[pQp]

How do I refer to a cell by using an offset reference to another?
My current targets are referred to by intersection off named columns and
rows -
eg: =monthtotal_JUL stock_bought gives me intersection of row
"monthtotal" and column "stock_bought", but now I want another reference to
cells above the "monthtotal" row (still in the stock_bought column) without
having to name the rows separately.
I played with the R1C1 convention ( R[-5] etc) but I'm not sure it's
compatible with the intersecting name reference, or if it is, just where to
put the offset within the reference.
Can someone help me with this.
Thanks peeps.

 

[Bob Phillips]

Are we in VBA or worksheet formulae?

If it's WF, then use
=OFFSET(monthtotal_JUL stock_bought,rows,cols,height,width)

if its VBA
Range("monthtotal_JUL stock_bought").OFFSET(Rows,columns)