=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