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

Advanced Excel functions Indirect; Vlookup & Indirect

Advanced Excel functions Indirect; Vlookup & Indirect

0
Votes
1
Answer

Notice that there are some errors in the exercise excel file for tab: VLOOKUP & INDIRECT.
The named ranges is different between the exercise file & solution file, causing learners unable to obtain the correct answer when they’re performing the exercise.

Exercise File

Solution

 

1 Answer

365 Team
0
Votes

Hi Wong!
Thanks for reaching out.
Can you please be more specific, perhaps supporting your question with screenshots? I just checked the two files and they seem to be correct.
Can you please confirm if we are both referring to the same lecture? Thank you. 
https://365datascience.teachable.com/courses/advanced-microsoft-excel/lectures/3644172
Looking forward to your answer.
Best,
Martin

Hi Martin, i have put in the images for you to refer. If you can see from the images, you may notice that the references of Q_1 to Q_4 are different between the exercise file and solution file.

5 months

Hi Wong! Great, thank you very much! The pictures are not needed any more – the file has been corrected. Thank you once again!

5 months
×
LAST CHANCE
Ready to Learn Data Science?
50% OFF