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

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

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

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.


--
Regards

Roger Govier


"Jani" wrote in message
...
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

--
kassie

never stop learning




"Jani" wrote in message
...
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