Worked perfectly and thanks for the quick response! Jani

"David Billigmeier" wrote:

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)

--
Regards,
Dave


"Jani" wrote:

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