• 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.

INDEX, MATCH WITH MULTIPLE CRITERIA

kkimiri

New Member
In the attached file, using the Tabs named ("Budget, Expenses and Budget Sector") please assist to calculate (index & match) the figures for the highlighted green cells in the Tab "Tables to input"
 

Attachments

  • MATCH, INDEX, SUMIF - MULTIPLE CRITERIA.xlsx
    13.1 KB · Views: 8
I have no idea what you want in the green boxes. If you don't know how to work it out, how do you expect anyone else to?

We can help you create a formula for a calculation that you can explain to us.
 
Just to make it a bit more clear, using the data set in the tabs named "Budget", "Expenses" and "Budget Sector" , would it be possible to create a formula that will get the results on the cells marked XX in the tab named " Tables to input"?

I do not have the results for the cells marked XX as this is the problem that I need to solve.

I hope this is more clear.
 

Attachments

  • MATCH, INDEX, SUMIF - MULTIPLE CRITERIA.xlsx
    13.1 KB · Views: 4
I don't understand why you are unable to fill in expected values manually.

Instead of "XX", tell us the cell or cells and sheet that the result needs to come from, then we can formulate a solution for you.

To be clear, I am NOT asking you to tell me what the formula should be, just where to find the relevant data so that I can create the formulae. You MUST know what results (values) that you are expecting in each of those green cells!
 
Back
Top