vlookups
 

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

vlookups
 

hcronrath;225610 Wrote:
How can I do a vlookup of a certain field, then sum certain colums from
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....T.html#classic) for more
info


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62616