The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Excel Formula

Excel Formula

0
Votes
1
Answer

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. 
Thank you.

 

1 Answer

365 Team
0
Votes

Hi Faizan,
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.
Best,
Ned