View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Juan is offline
external usenet poster
 
Posts: 70
Default Autofill down Vlookup formula between sum?

Hi,
I have a vlookup formula let's say in K2, is there a way to autofill down
but exclude sum totals?
Example
Vlookup formula
data
total sum Group1
data
total sum group2
grand total sum of group1 & 2
So I need to copy the vlookup between the sum totals. Is there a way?
any help would really appreciate.
thanks
Juan