Hi -

I am looking for a formula that will read criteria from one worksheet and pull it from another worksheet based on 3 categories to choose from, purchase, payment, misc. expense and populate the dollar amount based on one criteria.

The 1st worksheet, called "List" will list hundreds of transactions in addition to the 3 categories above. What I'm struggling with is creating a formula that will pull the data for the from the List worksheet into the 2nd worksheet called "Balances" for those specific categories based on the month criteria.

Here is what I'm (painfully) trying to do:
Create a formula in the Balances worksheet that will read -> In the List worksheet, if column A = January, Column B= product, & Column C=(the dollar amount for product in column B), populate the Balances worksheet Cell A2 with the month, Cell B2 with the product, and populate cell C2 with the dollar amount from the List worksheet.

Any & ALL help is GREATLY appreciated!

Thanks,

Kristen