P.S.

Also, this will not be able to reference column IV (256). You could do that
but then your simple reference method will turn out to be not so simple
afterall!

Biff

"Biff" wrote in message
...
Hi!

Try this:

=INDEX(MyRow,COLUMN()-1)

If you put this formula in column A it obviously can't refer to a column
to the left of column A so the value in column A will be returned.

Biff

wrote in message
ups.com...
I recently discovered naming entire rows -- it makes references super
easy (when your columns line-up). For example, if I name row 2
"MyRow", then in other cells I could just put "=MyRow" and it will
reference the cell in MyRow (row 2) that is in the same column where I
put the formula.

For example, if I put "=MyRow" in cell C6 it returns C2, in D6 it
returns D2, E6 -- E2, you get the idea.

My question is whether there is an easy way to offset this by one
column (so that putting "=MyRow" in cell C6 returns B2 instead of C2).
Something like "=MyRow[-1]" would be great. Any ideas? Thanks.