View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
not 2 excell not 2 excell is offline
external usenet poster
 
Posts: 1
Default How to copy a vlookup formula without changing the "table_array" p

I am trying to copy a vlookup formula to a whole column of cells with out the
formula changing the "table_array" part of the formula. When the formula is
copyed excell automaticaly changes the "lookup_value" to match the row number
that the cell is copied to. I want it to continue to do that without changing
the "table_array" part of the formula - Thanks in advance