Lookup and Reference Functions - Excel for Advanced - Lesson 2

Simply watching the videos is fine, but, if you want to fully benefit from this course, we recommend you do the Excel exercises while watching.
Download the exercise files:

We recommend watching all the lessons from the 'Excel for Beginners' and 'Advanced Excel' courses and then check your skills by doing the Excel Job Interview Tests, which are at the end of the 'Advanced Excel' course.

This video is best watched in high-definition. To change the quality, start the video, then click the cog icon in lower right-hand corner of the screen (Settings), select 'Quality' and then '720p HD'.

...and of course, don't forget to Like, Comment and Subscribe!

Lookup,and,reference,function,functions,vlookup,hlookup,lookup,excel,match,index,horizontal,vertical,look up,formula,formulas,Excel,how,to,course,comprehensive,courses,advanced,2016,2013,2019,MS,training,tutorial,Introduction,lessons,lesson,the most,useful,example,file,exercise,