View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wileyb Wileyb is offline
external usenet poster
 
Posts: 2
Default Array in formula Vlookup changes when data list is added to

How do I keep the array absolute in my formula when data is added to the list
that it refers to? "A$1$:E$40$" does not work. When data is moved in the
list, ie; when sorted, the array referenced in Vlookup moves with the
original data.