lookup row index number


G

Guest

I am using hlookup and vlookups and need to know how to increment the row
index number. Currently I am having to count from the last row I used the
formula. This creates problems when I later decide to delete rows.
 
Ad

Advertisements

Ad

Advertisements

G

Guest

To increase as you copy down, try: ROWS($1:1)+1,
eg: =HLOOKUP(A3,D$1:F$3,ROWS($1:1)+1,0)

To increase as you across, try: =COLUMNS($A:A)+1,
eg: =VLOOKUP($A2,$G:$I,COLUMNS($A:A)+1,0)
 

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

Top