INDEX MATCH |VLOOK UP |DATA VALIDATION|PRODUCTIVITY TIPS

This single video covers two major look up functions of Microsoft excel which are the Index Match function and the VLook up function. You will also be learning some productivity tips and tricks with detailed examples for you to scale through in the real life work environment. Go through my playlists to find other educative videos. https://youtube.com/playlist?list=PL5KFm9HsgsDd2n1EjQw5ooPVqbqFcxPNF&si=DY7VLDJbBe9_hov- https://youtube.com/playlist?list=PL5KFm9HsgsDeyHKOlfH0ZvcU068emF0Xi&si=rOkUz_RDJlyNWTrc https://youtube.com/playlist?list=PL5KFm9HsgsDe50HRGwTwUFlaQ5wIm1WyE&si=bAYjeowoLLun1fyo https://youtube.com/playlist?list=PL5KFm9HsgsDccCF-dQNw-mv63rwzfnAc6&si=xv8lNlF-0-LoxTWp Click on the link below to access this template so you can practice along while watching https://docs.google.com/spreadsheets/d/1lBPYTktuPXVGVOGyX2jYmekF8q__JvfD/edit?usp=drive_link&ouid=108977556217702238358&rtpof=true&sd=true The below timestamps will help you locate any specific area you are interested in 0:00- Intro 0:52- V Lookup Function 6:32- Index Function 9:02- Match Function 13:32- Index & Match Function 17:00- Productivity tips and tricks 22:43- Data Validation 23:35- Example 2