using contents of two cells to find another cell

[rkizziar]

I have created a ledger in xl2010 on one sheet, a budget on another sheet. I want to use the contents in the ledger; Date(Column A), and category(Column C, Mortgage, Electric, ect), to find the coordinating cell in the budget and auto populate the debt amount (Column E). The budget sheet is set up with the categories in column A, and the dates running in row 1. Being relatively new to formulas, i have no idea where to start with this. Any assistance with this would be greatly appreciated.

Thanks,
Rick

 

[TheCman81]

Can you post how you data looks and what you expect to be returned on your budget sheet?

This should be easily acheived using SUMIFS