D
Dylan @ UAFC
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
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