VLOOKUP Auto fill problem

[Dylan @ UAFC]

=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

 

[Niek Otten]

You seem to have messed up two systems of cell references: A1 and R1C1.

Define a name for your table (Insert>Name>Define) and use that in your
formula

 

[Fred Smith]

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.