Vlookup + match help

Kelly

New member
Joined
Dec 7, 2011
Messages
5
Reaction score
0
Points
0
Location
Sunnyvale, CA
I need a formula to look up a specific month, then find the P/N, then tell me the total qty for that P/N for that month.
Is this possible?
MONTHP/NQty
Nov
SA00163
NovSA00836
NovSA00835
DecSA01169
DecSA00837
 

maninweb

New member
Joined
Mar 22, 2011
Messages
88
Reaction score
0
Points
0
Location
Germany
Website
excel-translator.de
Excel Version(s)
2010, 2016, 2016 Insider
Hi Kelly...

I attached to this thread a sample workbook, which, perhaps, may help and includes a possible solution using a helper column. There are two sheets in the workbook, one assuming the Month names are entered as strings and one assuming the values are dates = numbers.

Best Regards :)
 

Attachments

  • Kelly.xlsx
    11.9 KB · Views: 25
Top