View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Using Lookup on an expanding list

Could you apply names to the table-array in the lookup function? Then
you could just increase the named range and not have to update any of
the lookups...