How do i make one cell get just the row amount from another cell?

[Wuggles]

I have a Formula that gets data from another tab
EXAMPLE:
=' TAB NAME'!$C$16
I want to be able to put a number in a different CELL that will change the
16 on the above formula... so if i a put a 19 in A1, the formula will get
information from the other tab, in the C Column, and the 19th row... (not
real good with excel terminalogy.. sry) Need this for updating a page...
with many different column Letters and the same 16, need to change them all
by hand at the moment.
Thanks in Advance
(please give examples as i may not understand it right away =P)

 

[Mike H]

Maybe this

=INDIRECT("Sheet2!$C"&A1)

Putting your number in A1 returns the calvie fron Cn

Mike

 

[Rick Rothstein \(MVP - VB\)]

Try this...

=INDIRECT("'TAB NAME'!C"&A1)

Rick

 

[Pete_UK]

Using the cell A1 to store 16 (or 19), change your formula to this:

=INDIRECT("' TAB NAME'!$C$"&$A$1)

Hope this helps.

Pete