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

  • Thread starter Thread starter Wuggles
  • Start date Start date
W

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)
 
Maybe this

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

Putting your number in A1 returns the calvie fron Cn

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

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

Hope this helps.

Pete
 
Back
Top