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

  • Thread starter Thread starter Neil
  • Start date Start date
N

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

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

Cheers

Neil
 
Back
Top