increasing the row_index_num when you drag a formula

  • Thread starter Thread starter Tblack78
  • Start date Start date
T

Tblack78

Here is my formula...

=HLOOKUP("Set #",'College Drop'!$1:$1048576,3,FALSE

I would like the row_index_num to increase as I drag the formula down.

Any help would be appreciated.

Thanks!
 
Try it like this assuming you want to start with row 3.

=HLOOKUP("Set #",'College Drop'!$1:$1048576,ROWS(A$1:A3),0)
 
Use: ROW() instead of a constant Number.
Micky
 
Back
Top