conditional länk to a cell

[fanch72]

Hi!

I am looking for a way to define a cell as equal to another cell depending on the line of the cell. For example I generate in cell A1 the number "3" and I want cell B1 to be equal to cell C3. B1 should be equal to $C"A1". This should hopefully work without a macro.
Thanks a lot
Francois

 

[xlbo]

in B1 enter
=Indirect("C" & A1) Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[Cresby]

INDEX is another possibility but not as easy.

It is worth considering using the ISBLANK(A1) or ISNUMBER(A1) tests for null or text entries.

eg = IF(ISVALUE(A1),Indirect("C" & A1),A1 & " non-numeric"

 

[fanch72]

Thanks a lot!
Francois