Hi Andrew

How about:

=INDEX($C:$C,B1)

Hope this helps!

Richard


Andrew wrote:

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