Hi Team, I am currently on “Using Index & Match as a substitute for Vlookup”. I am a bit confused that we have developed the code for our FY reports 2016-2018. However, when using these formulas to consolidate all the data in one sheet, we first look for 2016, then 2017, and then 2018, separately, to fill up our sheet.
But, in the previous lectures, we did the concept of duplication to reduce these codes. This means that if one code was present for the year 2016, there is a possibility that it might be present in 2017,2018, or both. So I am a bit confused about whether the execution done in this is right? If yes, please explain.
Yes, the execution is correct.
We took all the codes and we pasted them in one sheet. Then we removed duplicates. This ensures that we have all codes and that they are written in our P&L sheet only once. Hence you can use these values as a ‘lookup value’ to transfer other values and put the three years right next to each other.