Last answered:

18 May 2022

Posted on:

17 May 2022

0

Index match, I have problems in copying down the fomular to give me the results I want.

INDEX($C$5:$N$10,2,2) Jan

=INDEX($C$5:$N$10,2,3) Feb

=INDEX($C$5:$N$10,2,4) March
image.png
Looking at the formulas above and the table, I thought that when I copy the formula down the values will change but it didnt work. I have reviewed the solution many times and still cannot get it right nor see where I am gettting it wrong. Is there something I am not picking up ?

If I have to hard code every single formula, is this the reason why match function is used with the index function ?

3 answers ( 0 marked as helpful)
Instructor
Posted on:

17 May 2022

0

Hey Martin,
I think this lesson might be a bit confusing. Do you want to take a look here?
https://learn.365datascience.com/courses/introduction-to-microsoft-excel/index-match-and-their-combination-the-perfect-substitute-for-vlookup/
I'm confident this will clear your doubts. If not, will be happy to explain further until we get it right, because this is a very foundational aspect that I want you to learn before continuing further.
Best,
Ned

Posted on:

17 May 2022

0

Hi Ned,

Thanks for your quick reply. I have watch the lesson again. The best I can understand is that I must you the index and match function together in order to get the formula to change dynamically. Is this correct ?

Instructor
Posted on:

18 May 2022

0

Hi Martin,
Absolutely. That's correct. Do you need any additional help, please?
Best,
Ned

Submit an answer