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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row_Index_Num Increment 4
Changing the Row_index_num via HLOOKUP 2
HLookup, multiple tables and range names in other cells 2
dragging formula down makes a copy 2
Can the Row_Index_Num in HLOOKUP adjust relatively? 6
Hlookup? 1
copy formula - keep cell same but increment sheet numbers 5
Formula Drag Across Link Down 2

Back
Top