I think I see your point now. I am naming entire rows that are out of range
when looking for -2 columns. I assumed that the named range would carry the
logic of address with it as if I were referencing the cell (=namerange) which
would give me the cell's value that corresponds with exact column placement
on a different worksheet.

It still puzzles me why the =offset(namerange,0,0,,) would work as if I just
typed =namerange but that =offset(namerange,0,-2,,) will not.

"arno" wrote:

Hi StanJ,

The normal cell reference (=e69-c69) returns the correct answer.

ok.

what ist the adress of the top-left-cell of range "namerange"?
what ist the result of
=OFFSET(namerange,0,0,,)
and
=OFFSET(namerange,0,-2,,)
and
=row(namerange)
and
=column(namerange)


arno