increasing the row_index_num when you drag a formula

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

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
 
Top