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 ( 0 marked as helpful)
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.
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.