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

S

Sharon

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?
 
P

PaulW

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.
 
Top