software

So I'm creating a vlookup to look at an array of 500 values and return
to me the value (so I can compare a list of 3000 values to find which
500 are in the array). I've completed many vlookups over the years and
have always been able to just copy the first one and paste it down the
list of 3000 values to look up in the 500 value array and it would keep
looking at the same array. Well now all of a sudden this morning, it
decides to increment my array every step down. What the heck is going
on? For example, it should go like this....

=VLOOKUP(A2,'sheet2'!A1:A510,1,FALSE)
=VLOOKUP(A3,'sheet2'!A1:A510,1,FALSE)
=VLOOKUP(A4,'sheet2'!A1:A510,1,FALSE)
=VLOOKUP(A5,'sheet2'!A1:A510,1,FALSE)

and so forth, but instead, when I'm pasting or pasting special
(formulas), I get this...

=VLOOKUP(A2,'sheet2'!A1:A510,1,FALSE)
=VLOOKUP(A3,'sheet2'!A2:A511,1,FALSE)
=VLOOKUP(A4,'sheet2'!A3:A512,1,FALSE)
=VLOOKUP(A5,'sheet2'!A4:A513,1,FALSE)

What do I need to change for Excel to paste the formula like the first
set of examples?

Thanks,
-Scott H.That's why I always use named ranges for my vlookups (whenever reasonable to
do so), as described he
www.officearticles.com/excel/...soft_excel.htm
But you need to reference absolutely your table:
=VLOOKUP(A2,'sheet2'!$A$1:$A$510,1,FALSE)

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;Scott269quot; gt; wrote in message oups.com...
gt; So I'm creating a vlookup to look at an array of 500 values and return
gt; to me the value (so I can compare a list of 3000 values to find which
gt; 500 are in the array). I've completed many vlookups over the years and
gt; have always been able to just copy the first one and paste it down the
gt; list of 3000 values to look up in the 500 value array and it would keep
gt; looking at the same array. Well now all of a sudden this morning, it
gt; decides to increment my array every step down. What the heck is going
gt; on? For example, it should go like this....
gt;
gt; =VLOOKUP(A2,'sheet2'!A1:A510,1,FALSE)
gt; =VLOOKUP(A3,'sheet2'!A1:A510,1,FALSE)
gt; =VLOOKUP(A4,'sheet2'!A1:A510,1,FALSE)
gt; =VLOOKUP(A5,'sheet2'!A1:A510,1,FALSE)
gt;
gt; and so forth, but instead, when I'm pasting or pasting special
gt; (formulas), I get this...
gt;
gt; =VLOOKUP(A2,'sheet2'!A1:A510,1,FALSE)
gt; =VLOOKUP(A3,'sheet2'!A2:A511,1,FALSE)
gt; =VLOOKUP(A4,'sheet2'!A3:A512,1,FALSE)
gt; =VLOOKUP(A5,'sheet2'!A4:A513,1,FALSE)
gt;
gt; What do I need to change for Excel to paste the formula like the first
gt; set of examples?
gt;
gt; Thanks,
gt; -Scott H.
gt;

Anne Troy wrote:
gt; That's why I always use named ranges for my vlookups (whenever reasonable to
gt; do so), as described he
gt; www.officearticles.com/excel/...soft_excel.htm
gt; But you need to reference absolutely your table:
gt; =VLOOKUP(A2,'sheet2'!$A$1:$A$510,1,FALSE)
gt;

Ahh, the dollar signs for absolute, that's what I needed. Thanks!