View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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