using hlookup, I need the cell reference to add consec # to next
 

Example: Hlookup(a2,list,2). I have a long list where I want the formula
change to 2 to 3 and so on. Any suggestions?

using hlookup, I need the cell reference to add consec # to next
 

Hlookup(a$2,list,row(b2),false)

If you drag that down it will still be checking against A2, but will be
changing which row it returns

Hlookup($a2,list,column(b2),false)

if you're dragging right rather than down.

"Sharon" wrote:

Example: Hlookup(a2,list,2). I have a long list where I want the formula
change to 2 to 3 and so on. Any suggestions?