| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index and offset functions
I am pulling values from another spreadsheet within the same workbook and
need to increment the row munber by 1 when moving the formula down 22 lines. i.e. =+MON!$D$6 is in I62 and =+MON!D7 will be I84 =+MON!$D$6 =+MON!$E$6 =+TUES!$D$6 =+TUES!$E$6 =+MON!$G$6 =+MON!$H$6 =+TUES!$G$6 =+TUES!$H$6 =+MON!$J$6 =+MON!$K$6 =+TUES!$J$6 =+TUES!$K$6 =+MON!$M$6 =+MON!$N$6 =+TUES!$M$6 =+TUES!$N$6 thanks much!\ Denise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OFFSET vs INDEX(MATCH(...)) | Excel Discussion (Misc queries) | |||
| using OFFSET(INDEX(MATCH))) | Excel Discussion (Misc queries) | |||
| INDEX, MAX, OFFSET, MATCH | Excel Worksheet Functions | |||
| Index, Vlookup, Offset | Excel Worksheet Functions | |||
| Want to offset found value using Index | Excel Worksheet Functions | |||
Threaded Mode
