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 Absoult for auto fill

=VLOOKUP(D6,Sheet2!A1:K80000,11)

I need to make this formula absoult
so that can auto fill copy the coloumn
I just can't seem to place the $ corretly