Use the INDIRECT function, as such:

for your first question:

=INDIRECT("C"&A1,1)

for your second question

=INDIRECT("C"&(A1-40),1)

--OR--

=INDIRECT("C"&(A1-A2),1) where A2 holds the value 40 (or whatever value
you choose--this would save having to modify the formula if you need to
change the subtraction value).

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473143