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

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)

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

Maybe this

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

Putting your number in A1 returns the calvie fron Cn

Mike

"Wuggles" wrote:

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)

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

Try this...

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

Rick


"Wuggles" wrote in message
...
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)

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

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

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

Hope this helps.

Pete

On May 10, 10:11*am, Wuggles
wrote:
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)