VLOOKUP and Auto Fill problesm
 

Hopefully this is an easy one, none the less.
I have about a 100000 row spreedsheet.
That is running VLOOKUP table arrays to populate
most of the cells.
Problems, I have been using the auto fill handle to
try an fill a serious of these formulas.
But not matter how hard I try it fills out the
atble array as a serious too.
ie =VLOOKUP(a1,a1:b6,2)
=VLOOKUP(a2,a2:b7,2)

How can I get the look-up values to as auto fill
and leave the table array figures alone
Please advise
DYlan

VLOOKUP and Auto Fill problesm
 

How can I get the look-up values to as auto fill
and leave the table array figures alone

"Fix" the table array range with the dollar signs ($), ie make it absolute
=VLOOKUP(a1,$a$1:$b$6,2)

Then it won't change when you copy/fill down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---