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
 
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
Back
Top