exercise - index match march
It required us to compy the table and type in the formulas then change the months, this should change dynamically but in my case it didnt.
=INDEX($B$5:$N$10,MATCH($B25,$B$5:$B$10,0),MATCH(C$24,$B$5:$N$5,0))
Jan | Feb | Mar | Sep | Dec | Aug | |
Store A | 55 | 51 | 64 | 71 | 82 | 100 |
Store C | 58 | 48 | 80 | 81 | 90 | 95 |
Store D | 64 | 71 | 81 | 77 | 77 | 89 |
Hi Martin,
Can you please post a screenshot of your Excel as this would allow me to see easier and I will be able to help.
The formula that you've shown here looks a bit strange and I believe it contains an error. Please send me the screenshot and I will take a look at it right away.
Best,
Ned
This is the screenshot. I am not sure this is the exact copy you need.
This is the screenshot. I am not sure this is the exact copy you need.
Hi Martin and Ned!
I hope you don't mind if I join the conversation.
@Martin: Thank you very much for pointing this out. Indeed, we did have to adjust the lookup values of the MATCH() functions used within the formula you were supposed to create in Task 2. Hence, we've improved the text of Task 2 in the Exercise and Solution files. Both files are now updated in the relevant course lecture:
https://learn.365datascience.com/courses/advanced-microsoft-excel/advanced-excel-functions-index-match-match/
Hope this helps and thank you very much once again.
Kind regards,
Martin,
The 365 Team