• 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


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

Lookup value partaining in a particular month.


New Member
Hello Friends, Hope you all are good.

I am stuck in a problem, I have some monthly sales data. There can be multiple bill for various services rendered to parties in a month.
Now I wanted to lookup a sales bill using company name of a company for a particular service in a particular month.
suppose I wanted to lookup the invoice amount for Rent service of XYZ company in suppose Jan 20 month.
How do I do this, Please advise.



Active Member
in Query 1
in cell M5 ,you can use this
Query 2
in cell N11 ,
you can use this


Last edited: