View Full Version : Vlookup + match help
2011-12-07, 06:04 PM
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?
2011-12-08, 04:21 PM
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 :-)
2011-12-09, 04:18 PM
Thank you so much!!! That is exactly what I was looking for!!!!
2011-12-09, 06:52 PM
Hi Kelly, fine that it works, thanks :)
Powered by vBulletin® Version 4.2.0 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.