using an address stored in a cell to look up a value

[Neil]

I need to get a value into a cell in my spreadsheet. The address of the cell
is stored in another cell

so cell b1 contains the value "b30"
and I want cell b2 to contain the same value as is stored in b30.

Does anyone know how I go about this? The reason I need it is that the value
stored in B1 can change. Using the formula =cell("contents",b1) puts the
value "b30" into b2 and not the value stored in cell b30 as required.

Appreciate any help

Neil

 

[Peo Sjoblom]

Try

=INDIRECT(B2)

 

[Neil]

Peo

Thanks. That's the one. will save me hours of linking cells in a vertical
array to cells in a horizontal one

Cheers

Neil