• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lookup data

Steve Drew

New Member
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
 

Attachments

  • P&L.xls
    17 KB · Views: 8
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)))
 
Back
Top