Populating a worksheet from multiple IF statements

Hi Guys,

Okay i have an URGENT issue i have a worksheet where it has a drop down box for months of year, and another cell below for product.
Then below that i have three cells, exist,new,other.

So WORKSHEET#1
A B
Month <List>
Product <List>

NEW 1000 (these will change and want to keep the other worksheet
EXIST 2000 consistent with the details)
OTHER 3000

***************
So wat i want to do is i have anotehr sheet where only one cell references each. I want to populate the cell and save it (i am assuming Paste Special somewhere), VBA is fine.

Example, IF (B1 = "July") AND (B2 = "product1") then populate the corresponding cells for NEW, EXIST, OTHER on a sheet

*************************

WORKSHEET #2
A B
Month July

NEW
Product1 1000
Product2
EXIST
Product1 2000
Product2
...

Any other questions let me know. Thanks for your help

email address to use kaitlyn_wright@technologyonecorp.com