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.
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.
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.
Hi Wong! Great, thank you very much! The pictures are not needed any more – the file has been corrected. Thank you once again!