| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The sum of multiple returns on a vlookup
I am trying to get the sum of multiple returns on a VLOOKUP. As an example:
Jan 24 Jan 57 Jan 239 Feb 72 Mar 16 Mar 44 I want to get a result that looks like: Jan Feb Mar 320 72 60 I have tried: =SUMPRODUCT(VLOOKUP((Jan,A2:B7,2,FALSE)) But unfortunatley that just returns 24. I hope someone can help. Alibo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add multiple returns using vlookup | Excel Worksheet Functions | |||
| VLOOKUP - MULTIPLE RETURNS | Excel Worksheet Functions | |||
| Vlookup with multiple returns | Excel Worksheet Functions | |||
| VLOOKUP Returns #REF | Excel Worksheet Functions | |||
| Vlookup Multiple Returns #REF | Excel Discussion (Misc queries) | |||
Threaded Mode
