cell
=INDIRECT("E"&A1)
--
David Biddulph
"Nigel123" wrote in message
...
Hi I was wondering if someone can help me......
Basically I need a formula that will show me the substance of a cell
for example
cell A1 says 5
and I want this cell to automatically show me the substance of cell E5
and if i was to chance the 5 to a 8 the cell will show me the substance of
cell E8
|