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.
 

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

HLOOKUP static cell reference 1
HLOOKUP - Relative cell reference in row index number 0
Hlookup 0
Lookup formula 2
COMPLICATED FORMULA WITH EMBEDDED HLOOKUP 2
Excel - Wich Function should I use? 1
Offset with hlookup as reference 4
hlookup in array 2

Top