Practice Video: Exact Matches: Exact Match VLOOKUP

Loading...
View Syllabus

Skills You'll Learn

Lookup Table, Microsoft Excel Vba, Data Validation, Microsoft Excel Macro

Reviews

4.8 (3,632 ratings)
  • 5 stars
    83.48%
  • 4 stars
    14.09%
  • 3 stars
    1.89%
  • 2 stars
    0.27%
  • 1 star
    0.24%
UA

Jul 21, 2020

Practice Challenge of Week 6 is very difficult. It would be great if the team could add the step by step video on how to solve that challenge. It will be a big help for all the future learners.

AM

Apr 16, 2020

I really enjoy each and every learning exercise, the course is designed in a very well as exercises, tips, practice challenges are very well designed and ensured we learned from fundament.

From the lesson
Automating Lookups
How do you find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.

Taught By

  • Nicky Bull

    Nicky Bull

    Excel Consultant
  • Dr Prashan S. M. Karunaratne

    Dr Prashan S. M. Karunaratne

    Lecturer - Teaching & Leadership | FHEA
  • A/Professor Yvonne Breyer

    A/Professor Yvonne Breyer

    Director, Learning & Teaching| Head, Learning Futures

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.