Which is faster? SUMPRODUCT or VLOOKUP, or another alternative?
Whilst I would (reasonably) guess that VLOOKUP is faster, it is not just a
question of speed but of functionality.
If there are two items in the lookup range with the value in C44, VLOOKUP
returns the value associated with the first, SUMPRODUCT sums both associated
values. It depends upon what you want to do which one you choose.
--
HTH
Bob Phillips
(replace somewhere in email address with googlemail if mailing direct)
"SteveC" wrote in message
...
=VLOOKUP(C44,'Sheet1'!$C$13:$AA$3000,25,FALSE)
=SUMPRODUCT(--($D13='Sheet1'!$D$13:$D$3000),'Sheet1!AA$13:AA$300 0)
|