| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Help
I am trying to get an Index function to work and having some difficulty.
In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from sheetA, cell E19, (then E33, E47, E51)... Any ideas? Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Index Help
One way:
SheetB!C3: =INDEX(SheetA!E:E,(ROW()-3)/6*14+19) copy to C9, C15, etc. In article , iRon924 wrote: I am trying to get an Index function to work and having some difficulty. In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from sheetA, cell E19, (then E33, E47, E51)... Any ideas? Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Index Help
JE, that worked beautifully! Thanks so much for the help!
"JE McGimpsey" wrote: One way: SheetB!C3: =INDEX(SheetA!E:E,(ROW()-3)/6*14+19) copy to C9, C15, etc. In article , iRon924 wrote: I am trying to get an Index function to work and having some difficulty. In sheetB, cell C3,(then C9, C15, C21...) I am trying to pull the value from sheetA, cell E19, (then E33, E47, E51)... Any ideas? Thanks in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with: INDEX() / MOD ? | Excel Discussion (Misc queries) | |||
| INDEX | Excel Discussion (Misc queries) | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
| INDEX | Excel Worksheet Functions | |||
Hybrid Mode
