Jase Alexander
asked on
Excel INDEX MATCH with multiple criteria
Hi Experts
Hope you can help
I have a spreadsheet with some performance data extracted and entered manually from some reports
There is a summary section (in green) to the right of the graphs and now this is being calculated per week (after receiving some superb assistance yesterday), I need to present a weekly summary for reporting purposes
For this ive created a drop down in cell A2 from the weeks presented in the summary (in green) and underneath have replicated the various categories over which I intent to insert some simple pie charts
However, Im struggling to use INDEX MATCH to successfully extract the data from the summary section (in green) for the corresponding week when selected against the appropriate category
For example, if week 13 is selected from the drop down, the all the values under 13 in the summary section should assign to the corresponding category. For example, for the first one, Int to Rec, the result should be 0 in cell B6 and if 14 is selected, then this change to 3 in B6 and so on for the other categories.
If anyone can help with creating a formula to perform this it would be greatly appreciated
J
Copy-of-Copy-of-USA-KPI-Draft--2.xlsx
Hope you can help
I have a spreadsheet with some performance data extracted and entered manually from some reports
There is a summary section (in green) to the right of the graphs and now this is being calculated per week (after receiving some superb assistance yesterday), I need to present a weekly summary for reporting purposes
For this ive created a drop down in cell A2 from the weeks presented in the summary (in green) and underneath have replicated the various categories over which I intent to insert some simple pie charts
However, Im struggling to use INDEX MATCH to successfully extract the data from the summary section (in green) for the corresponding week when selected against the appropriate category
For example, if week 13 is selected from the drop down, the all the values under 13 in the summary section should assign to the corresponding category. For example, for the first one, Int to Rec, the result should be 0 in cell B6 and if 14 is selected, then this change to 3 in B6 and so on for the other categories.
If anyone can help with creating a formula to perform this it would be greatly appreciated
J
Copy-of-Copy-of-USA-KPI-Draft--2.xlsx
ASKER
Hi Egjil
I see - there are two types of receipts we perform for international deliveries and domestic deliveries
I believe I will have to change the one so it is unique - maybe to Late RecI for international and Late RedD for Domestic so the correct results are extracted for each
Regards
J
I see - there are two types of receipts we perform for international deliveries and domestic deliveries
I believe I will have to change the one so it is unique - maybe to Late RecI for international and Late RedD for Domestic so the correct results are extracted for each
Regards
J
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Ejgil
Wow thank you so much
I cant tell you how much I appreciate your help
J
Wow thank you so much
I cant tell you how much I appreciate your help
J
Should the result be the sum, or is it an error that it is duplicated.