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

  • Thread starter Thread starter Sharon
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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
How to increase the row num in hlookup 0
Offset with hlookup as reference 2
Why hlookup error when I insert table array formula? 2
Hlookup error 3
hlookup problem 3
hlookup in array 2

Back
Top