Carin
Board Regular
- Joined
- Feb 4, 2006
- Messages
- 224
I would like to autofill a vlookup. What I'm trying to get is the column index number to increase by 1.
Example:
B1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,4,FALSE)
C1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,5,FALSE)
D1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,6,FALSE)
When I drag the cell, the column index stays at 4.
Thanks
Example:
B1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,4,FALSE)
C1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,5,FALSE)
D1
=VLOOKUP($A$1,'Anchorage AK'!$A$1:$W$26,6,FALSE)
When I drag the cell, the column index stays at 4.
Thanks