Hello,

I have taken some training on excel and access. I am at a point where I have reports from access that are exported to excel from our works software that holds our data. In this example, the access report is grabbing Purchase orders including the purchase order number, products on the purchase order, quantity of products, and date it is due in. On a new worksheet we have a forecasting tool. I would like this tool to automatically update. I want a column of cells to grab from the other/imported access report, grab the PO number if the due date is in the associated month. When it returns a cell that is in the month, I then want it to put in the next cell, the quantity of the product.

Product 1
Jan - PO number - amount due in
Feb - PO number - amount due in
Mar - PO number - amount due in
and so on.

Product 2 in a new tab
Jan - PO number - amount due in
Feb - PO number - amount due in
Mar - PO number - amount due in

I keep a different tab for about 20 different products. The imported access report has all products on it. So on top of everything else, the function needs to first identify the product by name, then figure our what month it is coming in, place the Purchase order number in the cell "PO number", and then place the quantity of that product coming in "amount due in"

I know this is confusing. The sheet is much more detailed, but hopefully this can get my point accross.

I have toyed with the vlookup and if functions, but cannot wrap my head around it.

Thanks for any help