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