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

<barbetta3141@yahoo.com> wrote in message
news:1152220714.294010.113130@75g2000cwc.googlegroups.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.
>