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 ?
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
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 ?