| 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) |
| 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) | |||
Threaded Mode
