Last answered:

21 Apr 2020

Posted on:

17 Apr 2020


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.

Exercise File



1 answers ( 0 marked as helpful)
Posted on:

21 Apr 2020


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.
Looking forward to your answer.

Submit an answer