Advanced Excel functions Indirect; Vlookup & Indirect
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.


1 answers ( 0 marked as helpful)
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://learn.365datascience.com/courses/advanced-microsoft-excel/advanced-excel-functions-indirect-vlookup-indirect
Looking forward to your answer.
Best,
Martin