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

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 ?

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,