Vlookup + match help

[Kelly]

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?


MONTH
P/N
Qty


Nov

SA0016
3


Nov
SA0083
6


Nov
SA0083
5


Dec
SA0116
9


Dec
SA0083
7

[maninweb]

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 :-)

[Kelly]

Thank you so much!!! That is exactly what I was looking for!!!!

[maninweb]

Hi Kelly, fine that it works, thanks :)