Home |
Search |
Today's Posts |
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I lookup when match has more than one value?
Hi, I have the same query i.e. sum of multiple vlookups....I'd be very
interested to get advice "Ray" wrote: Hi, I have a similar question on return sum of multiple vlookup values. Please see the following array. Item Date Amount a 1-Sep 10 b 1-Sep 15 c 1-Sep 20 a 2-Sep 16 c 2-Sep 21 d 2-Sep 30 a 3-Sep 18 b 3-Sep 25 I want the function return the sum of values which 'Item' = 'a'. I used =sum(vlookup(a, a2:c9, 3, false)) and it only returned the first value 10. I expected to get (10+16+18) = 44. How can I achieve this result? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Lookup | Excel Worksheet Functions | |||
using MATCH, and LOOKUP | Excel Worksheet Functions | |||
match, lookup ??? | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup or Match | Excel Worksheet Functions |