Hi StanJ,

I think I see your point now. I am naming entire rows that are out of
range when looking for -2 columns.

so, if your column C is "myrange", you are in row 14 and you want to
go -2 colums - and you definetily think you need the offset command in
your case (think about it!!!) then you could write into B14:

=offset(myrange,row(b14)-1, -2, 1, 1)

arno