1. First, you need to fix the formula. E11K28664 is not a proper cell
address. You probably want:
=VLOOKUP(D6,Sheet2!E10:K28664,2)

2. To make the table address absolute, use:
=VLOOKUP(D6,Sheet2!$E$10:$K$28664,2)

3. To copy down, drag the fill handle (the small black box on the bottom
right of the highlighted cell) down.

4. When you omit the fourth parameter of Vlookup, it assumes you want an
approximate match (ie, your table is sorted in ascending order). If you want
an exact match, use:
=VLOOKUP(D6,Sheet2!$E$10:$K$28664,2,false)


Regards,
Fred.


"Dylan @ UAFC" wrote in message
...
=VLOOKUP(D6,Sheet2!E10:E11K28664,2)

How can I make this formula absoult.
So I can copy down the column.
I have tried several way witht $ but
I cant figure it out
please advsei