increasing the row_index_num when you drag a formula
 

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!

increasing the row_index_num when you drag a formula
 

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

=HLOOKUP("Set #",'College Drop'!$1:$1048576,ROWS(A$1:A3),0)

--
Biff
Microsoft Excel MVP


"Tblack78" wrote in message
...
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!

increasing the row_index_num when you drag a formula
 

Use: ROW() instead of a constant Number.
Micky


"Tblack78" wrote:

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!