Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Vlookups | Excel Discussion (Misc queries) | |||
VLOOKUPS | Excel Discussion (Misc queries) | |||
Vlookups | Excel Worksheet Functions | |||
Vlookups | Excel Discussion (Misc queries) |