Variable Cell Reference

[Andrew]

In A1 I want to show the value of cell Cx where x is a variable held in B1
eg.

B1= 5
A1 should show the value of C5

How can I do it please/

TIA
Andy

 

[RichardSchollar]

Hi Andrew

How about:

=INDEX($C:$C,B1)

Hope this helps!

Richard