| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row_Index_Num Increment
Is there a way when doing a HLookup and pulling the formula down, to have the
row_index_num automatically increment by 1? Perhaps i'm not using the best function. Here's my formula: =HLOOKUP($C$1,$G$4:$T$316,27,FALSE). This is used to get the date for the month as specified in C1, from the appropriate data in G4:T316. It's taking way to much time to edit each formula! Thanks so much! Jani |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Scroll bar' - to increment btwn MIN and MAX value. | Charts and Charting in Excel | |||
| How do you force a copy to increment by 1 in Excel? | Excel Discussion (Misc queries) | |||
| check cell val, increment val | Excel Worksheet Functions | |||
| need to increment value | Excel Discussion (Misc queries) | |||
| Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
Threaded Mode
