Last answered:

09 Jul 2023

Posted on:

26 Jun 2023

0

Resolved: Could you please share where exactly is the "Homework day 4" solution?

I couldnt find the file. The one with the 4 Quarter tables and the 4 potential functions that could be used... . Thanks for helping.

2 answers ( 1 marked as helpful)
Posted on:

26 Jun 2023

0

I'm trying to create multipley dependant dropdown lists, that draw data from the 4 seperate Quarter tables above them:

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

09 Jul 2023

1

The formula at the D15 cell is: =SUM(OFFSET(INDIRECT(C15),MATCH(B15,B6:B10,FALSE),1,1,3)) 


You have to create the 2 dropdown lists but pay attention that the quarters in the second dropdown list should be written as Q_1, Q_2 etc. instead of  Q1, Q2 etc. because they are named this way.

Submit an answer