| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula question
this is continued from my post last week.. (9/27/2007)
I need Sheet 1 to look up sheet 2 so that I have the following; D5 (sheet 1) = D14 (sheet2) F5 = G14 H5 = J14 etc.. (so every 3rd column in sheet 2) I am using the following formula =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) however each cell i copy the formula into returns the value from D14 on sheet 2?? Can anyone tell me what im doing wrong?... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
I am having an absolute shocker of a day.. let me ammend my problem...
D5(Sheet 1) = D14 (sheet 2) D6 = G14 D7 = J14 etc... So i have rows in sheet 1 that need to look at every 3rd column in sheet 2.. "Scott R" wrote: this is continued from my post last week.. (9/27/2007) I need Sheet 1 to look up sheet 2 so that I have the following; D5 (sheet 1) = D14 (sheet2) F5 = G14 H5 = J14 etc.. (so every 3rd column in sheet 2) I am using the following formula =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) however each cell i copy the formula into returns the value from D14 on sheet 2?? Can anyone tell me what im doing wrong?... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula question
dont worry guys. the formula actually worked, i was doing it wrong, sorry
"Scott R" wrote: I am having an absolute shocker of a day.. let me ammend my problem... D5(Sheet 1) = D14 (sheet 2) D6 = G14 D7 = J14 etc... So i have rows in sheet 1 that need to look at every 3rd column in sheet 2.. "Scott R" wrote: this is continued from my post last week.. (9/27/2007) I need Sheet 1 to look up sheet 2 so that I have the following; D5 (sheet 1) = D14 (sheet2) F5 = G14 H5 = J14 etc.. (so every 3rd column in sheet 2) I am using the following formula =INDEX('Sheet 2'!$14:$14,1+3*ROWS(A$1:A1)) however each cell i copy the formula into returns the value from D14 on sheet 2?? Can anyone tell me what im doing wrong?... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula question | Excel Worksheet Functions | |||
| Formula Question | Excel Discussion (Misc queries) | |||
Linear Mode
