Lookup data

[Steve Drew]

Hi
I am trying to look up data from a column in another sheet based on date. For my P&L I need to see what expenditure there was in a particular month for each category. Is this possible? I have tried using pivot tables, but it got very messy.
Cheers

 

[vletm]

Is this too messy?

 

[AVK]

In "C12"
=SUMPRODUCT((Sheet1!$B$3:$B$10)*(Sheet1!$C$3:$C$10=Sheet2!$A12)*(MONTH(Sheet1!$A$3:$A$10)=MONTH(Sheet2!C$2&0)))

 

[Steve Drew]

In "C12"
=SUMPRODUCT((Sheet1!$B$3:$B$10)*(Sheet1!$C$3:$C$10=Sheet2!$A12)*(MONTH(Sheet1!$A$3:$A$10)=MONTH(Sheet2!C$2&0)))

Works perfectly and I don't have to change my format for the accountant. Thank you sooo much.

 

[Steve Drew]

Is this too messy?
View attachment 43467

Looks loads better than mine. Not sure what I was doing wrong. Cheers

 

[vletm]

Steve Drew
You could compare ..
then no need to use formulas.