Vlookup question

[evanlenoir]

I am setting up a personal finances budget in Excel. One worksheet is committed to being a "transactions" worksheet that has columns for: DATE/CHECK NUMBER/DESCRIPTION/DEBIT/CREDIT/BALANCE.

I have another worksheet that is being used as a budget worksheet. I want to be able to pull information from the "transactions" worksheet AUTOMATICALLY. I want to be able for a particular cell to look up the SUM of a particular "description" within a range of dates (such as within the month of march) from the "transactions" worksheet.

I am pretty sure its going to have to be a vlookup of a vlookup but I am not sure.. can anyone help?

Thanks so much.

[franciz]

Hi

Would SUMPRODUCT do what you want?
Why not post your sample and we shall see what can be done

cheers, francis

[evanlenoir]

Here's the file! So basically I want to be able for the "budget" worksheet to automatically pull from the "transactions" sheet. I want it to pull the transactions for the "pay period" starting from the date that the user inputs in the "start of pay period" to "today". And I want it to organize the transactions by "description" from the transaction worksheet... I want them to sum, and the final output be in the "Actual" column (C) of the "Budget" worksheet.

I hope this helps.

[bbcalagu]

You have to write vba.
your request is like you want to complete your the project for you.