Absoult for auto fill

[Dylan @ UAFC]

=VLOOKUP(D6,Sheet2!A1:K80000,11)

I need to make this formula absoult
so that can auto fill copy the coloumn
I just can't seem to place the $ corretly

 

[Bernie Deitrick]

Dylan,

At the minimum, I would use

=VLOOKUP(D6,Sheet2!A$1:K$80000,11)

and possibly

=VLOOKUP(D6,Sheet2!$A$1:$K$80000,11)
or
=VLOOKUP($D6,Sheet2!A$1:K$80000,11)

depending on how you want things to increment when (if) you copy to the
right.

HTH,
Bernie
MS Excel MVP