Referencing a referenced cell

[zozo]

Hi guys,
I'm having trouble making the computer follow a cell value as another cell reference. i h\need this because i am creating formulas which decide which cell to look at from the given data. here's an example:

A1 contains -[ 3 ]
B3 contains [ flower ]
a2 contains [ ="B"&A1 ] and shows [ B3 ]
A3 contians [ = A2 ]
How do i make it show [ flower ] ?

[mikerickson]

I'm not sure what depends on which in your scheme, but INDIRECT should help you do what you want.