Row_Index_Num Increment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=HLOOKUP(C1,$G$4:$T$316,27,FALSE). Iow, make C1 relative, not absolute.
You can also use $C1
 
Create a helper column to the right or left of your formula that increments
each time, i.e. in A1 have 1, and then A2=A1+1, and drag this down. Then
change the hard coded row_index_num in your formula to this new column, e.g.:

=HLOOKUP($C$1,$G$4:$T$316,A1,FALSE)
 
Hi Jani

Try using the Row() function which will increment as you copy down.
=HLOOKUP($C$1,$G$4:$T$316,ROW(27:27),FALSE)

If you wanted to increment when copying across the page,
you can use COLUMN(AA:AA) (for 27) in the same way.
 
Back
Top