Autofill Formula

T

tqdinh22

Hello,

I am having some trouble with the clicking and dragging to autofill
vlookup formula. I currently have a Vlookup referenced to a second dat
sheet and when I click and drag down to copy the formula, I would lik
the lookup value to change, but not the table reference values fo
example, I would like it to show like this as oppose to changing th
referenced "PA Data" rows:

=VLOOKUP(H994,'PA Data'!B2:G1427,6,FALSE)
=VLOOKUP(H995,'PA Data'!B2:G1427,6,FALSE)
=VLOOKUP(H996,'PA Data'!B2:G1427,6,FALSE)
=VLOOKUP(H997,'PA Data'!B2:G1427,6,FALSE)

Can I change the autofill to do this instead of changing the rows o
the reference sheet as well?

Thank
 
R

Ragdyer

Look up relative and absolute cell references in the Help files.

Your formula should look like this:

=VLOOKUP(H994,'PA Data'!$B$2:$G$1427,6,FALSE)

*Before* copying own.
The $ signs prevent cell references from incrementing during a "Copy".
 
Top