lookup row index number

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

 

[Tim879]

Try using a dynamic range:
http://www.google.com/search?q=dyna...avclient-ff&ie=UTF-8&rlz=1B3GGGL_enUS228US228

http://www.google.com/url?sa=t&ct=r...Zdcu679p4Mp2S5OlA&sig2=OiAn_U5uky2NrG4Iff8VBw

 

[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)