On Sat, 13 Jun 2009 06:49:09 -0700 (PDT), Fan924
wrote:

I have line number 130 stored in cell A1. In A2, I want it to load the
contents of C130. If I change A1 to say 140, the contents of C140
should appear in A2. Not sure how to code this. TIA


Here is another one you can try in cell A2:

=INDIRECT("C"&A1)

Hope this helps / Lars-Åke