| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I write an infinite amount in a cell with expanding the cell? | Excel Discussion (Misc queries) | |||
| How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
| sales tax total amount from one cell amount to another cell | Excel Discussion (Misc queries) | |||
| make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
| large text amount in cell will not display in the cell | Excel Discussion (Misc queries) | |||
Linear Mode
