View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dylan @ UAFC[_2_] Dylan @ UAFC[_2_] is offline
external usenet poster
 
Posts: 76
Default 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