VLOOKUP and Auto Fill problesm

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
 
M

Max

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

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