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 ?