VLOOKUP Auto fill problem
 

=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

VLOOKUP Auto fill problem
 

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

Define a name for your table (InsertNameDefine) and use that in your
formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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

VLOOKUP Auto fill problem
 

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