Last answered:

27 May 2022

Posted on:

17 May 2022

0

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
5 answers ( 0 marked as helpful)
Instructor
Posted on:

18 May 2022

0

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

Posted on:

20 May 2022

0

image.png

Posted on:

20 May 2022

0

This is the screenshot. I am not sure this is the exact copy you need.

Posted on:

20 May 2022

0

This is the screenshot. I am not sure this is the exact copy you need.

Instructor
Posted on:

27 May 2022

0

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

Submit an answer