Link to home
Start Free TrialLog in
Avatar of Jase Alexander
Jase AlexanderFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Late Rec are in AO20 and also in AO22.
Should the result be the sum, or is it an error that it is duplicated.
Avatar of Jase Alexander

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
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Ejgil

Wow thank you so much

I cant tell you how much I appreciate your help

J