increasing the row_index_num when you drag a formula

[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!

 

[T. Valko]

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