| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
increasing the row_index_num when you drag a formula
Here is my formula...
=HLOOKUP("Set #",'College Drop'!$1:$1048576,3,FALSE I would like the row_index_num to increase as I drag the formula down. Any help would be appreciated. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increasing the row_index_num when you drag a formula
Try it like this assuming you want to start with row 3.
=HLOOKUP("Set #",'College Drop'!$1:$1048576,ROWS(A$1:A3),0) -- Biff Microsoft Excel MVP "Tblack78" wrote in message ... Here is my formula... =HLOOKUP("Set #",'College Drop'!$1:$1048576,3,FALSE I would like the row_index_num to increase as I drag the formula down. Any help would be appreciated. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
increasing the row_index_num when you drag a formula
Use: ROW() instead of a constant Number.
Micky "Tblack78" wrote: Here is my formula... =HLOOKUP("Set #",'College Drop'!$1:$1048576,3,FALSE I would like the row_index_num to increase as I drag the formula down. Any help would be appreciated. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| day increasing by 1 when i drag and drop | Excel Worksheet Functions | |||
| Hlookup-row_index_num question | Excel Worksheet Functions | |||
| Row_Index_Num Increment | Excel Worksheet Functions | |||
| Increasing distance labels using drag down method | Excel Worksheet Functions | |||
| Changing the Row_index_num via HLOOKUP | Excel Worksheet Functions | |||
Linear Mode
