vlookups

hcronrath · Feb 11, 2009

How can I do a vlookup of a certain field, then sum certain colums from a
large table that match the looked up field?

Pecoflyer · Feb 11, 2009

hcronrath;225610 said:
How can I do a vlookup of a certain field, then sum certain colums fro
a
large table that match the looked up field?

Maybe SUPRODUCT is what you are looking for
Have a look 'here
(http://www.xldynamic.com/source/xld.SUMPRODUCT.html#classic) for mor
inf

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste