Index match, I have problems in copying down the fomular to give me the results I want.
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 ?
I think this lesson might be a bit confusing. Do you want to take a look here?
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.
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 ?