Practice Video: Exact Matches: Exact Match VLOOKUP

Video placeholder
Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (8,005 ratings)

  • 5 stars
    84.52%
  • 4 stars
    13.09%
  • 3 stars
    1.79%
  • 2 stars
    0.36%
  • 1 star
    0.22%

DM

Mar 7, 2019

Love this course....It taught me a lot. It was little more challenging but I passed it. I definitely need more practice at doing these formulas and equations. Thank You for offering this great course

EK

Dec 17, 2020

Thank you, dear all Prashan, Nicky and Yvonne! The teaching course has been concise, clear and very user friendly!

I have enjoyed my learning of MS Excel Intermediate II with MacQuarie University.

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

  • Placeholder

    Nicky Bull

    Lecturer and Lead Content Designer

  • Placeholder

    Dr Prashan S. M. Karunaratne

    Senior Lecturer - Teaching & Leadership | SFHEA

  • Placeholder

    Professor Yvonne Breyer

    Deputy Dean, Education and Employability

Explore our Catalog

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