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