INDEX Function
The INDEX function in Excel is a built-in function that allows you to retrieve the value from a specified position within a range or array.

Task

We possess a dataset that includes four print areas: Apples, Bananas, Lemons, and Pears. In cell C2, we can choose quarters; in cell C3, regions; and in cell C4, print areas. The Switch function converts the selected data in column C into numerical values in respective cells in D Column.

Cell Q17 should display the required information according to the selected details in cells C2, C3, and C4.

Simultaneously, display the data in Cells P20:S20 for all regions based on the selections made in cells C2 and C4.

Submission
Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.

Regarding this subtask:
“Simultaneously, display the data in Cells P20:S20 for all regions based on the
elections made in cells C2 and C4”
Kindly look at the formula in cell P20, despite not adding the column (the sales region) as the task only asks to reference cells C2 & C4, the formula works but I don’t know why, how is it determining the column?
Also, when did the Index function become dynamic? I see the active cell in P20 and greyed out inQ20…S20.

Thank you for participating in the Excel Challenge related to Index Function! I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to work with Index Function in Excel.

Challenge #21 with Solution.xlsx (8.3 MB)
Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!