reference question #2

[david]

A few days ago, some kind person introduced me to the INDIRECT function
as a way of keeping a formula pointed at a fixed cell even after I've
inserted a column or two on the worksheet. (Thank you!)

Turns out, though, that while I need that fixed reference to a given
column, I actually want a relative reference to the rows on the worksheet.

Does anyone have a suggestion about how to set my formula up so the
reference to a given column is absolute but the row floats?

Thanks!

[Peo Sjoblom]

=INDIRECT("B"&ROW(1:1))

for B1

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"david" <[email protected]> wrote in message
news:[email protected]...
>A few days ago, some kind person introduced me to the INDIRECT function as
>a way of keeping a formula pointed at a fixed cell even after I've inserted
>a column or two on the worksheet. (Thank you!)
>
> Turns out, though, that while I need that fixed reference to a given
> column, I actually want a relative reference to the rows on the worksheet.
>
> Does anyone have a suggestion about how to set my formula up so the
> reference to a given column is absolute but the row floats?
>
> Thanks!