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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wuggles - 10 May 2008 10:11 GMT

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)

Reply to this Message

Mike H - 10 May 2008 10:31 GMT

Maybe this

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

Putting your number in A1 returns the calvie fron Cn

Mike

> I have a Formula that gets data from another tab
> EXAMPLE:
[quoted text clipped - 7 lines]
> Thanks in Advance
> (please give examples as i may not understand it right away =P)

Reply to this Message

Rick Rothstein (MVP - VB) - 10 May 2008 10:35 GMT

Try this...

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

Rick

>I have a Formula that gets data from another tab
> EXAMPLE:
[quoted text clipped - 8 lines]
> Thanks in Advance
> (please give examples as i may not understand it right away =P)

Reply to this Message

Pete_UK - 10 May 2008 11:06 GMT

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 <Wugg...@discussions.microsoft.com>
wrote:

> I have a Formula that gets data from another tab
> EXAMPLE:
[quoted text clipped - 7 lines]
> Thanks in Advance
> (please give examples as i may not understand it right away =P)

Reply to this Message