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?