HLookup Index number Auto Decrease

Hello,

I have a document with 150+ rows of data. The data has a few HLookups in each row that will look for a specific value and then reference to a specific time interval. I can get the first row of forumlas to return the correct values, but when i drag the formula down the document, the Row_Index_Num does not change. I am having to manually change the Index # to reflect the data i am wanting to return.

Is there anyway to have the row index # change automatically? The row index # i want every formula to reference is in 1 single row (row 77), itdoes not move or change

here is what i have

Cell E7: =HLOOKUP(E$5,$K7:$CJ$77,71,FALSE)
Cell E8: =HLOOKUP(E$5,$K8:$CJ$77,70,FALSE)
Cell E9: =HLOOKUP(E$5,$K8:$CJ$77,69,FALSE)

Can anyone help with this?

Thank you!

Re: HLookup Index number Auto Decrease

Thank you Cytop for the reply.

So, the references for the lookup Value should be constant. I want to use E5 as the Lookup Value for each row and also have K7:CJ77 as the table array for each Hlookup in each row. I only need the "row_index_num" to decrease by 1 as i drag the formula down through each row.

Re: HLookup Index number Auto Decrease

Yea, each row_index_num needs to reference to row 77. As I drag the formula down, i need to manually decrease the Row_Index_num by 1 for each row, in order to reference back to row 77