Thread: Which is faster? SUMPRODUCT or VLOOKUP, or another alternative?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveC
 
Posts: n/a
Default Which is faster? SUMPRODUCT or VLOOKUP, or another alternative?
=VLOOKUP(C44,'Sheet1'!$C$13:$AA$3000,25,FALSE)


=SUMPRODUCT(--($D13='Sheet1'!$D$13:$D$3000),'Sheet1!AA$13:AA$300 0)

Reply With QuoteReply With Quote