Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
4.3 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
441 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups to your Wishlist.

Add to Wishlist

Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups

Master the use of lookup functions like VLOOKUP, INDEX MATCH, OFFSET, and INDIRECT to automate your work!
4.3 (33 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
441 students enrolled
Created by Sam McIntire
Last updated 7/2016
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • 1 Article
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use VLOOKUP, INDEX MATCH, and other advanced formulas to automate work in Excel
  • Perform advanced lookups based on both rows and columns at the same time
  • Employ array functions to create complex formulas that pull data based on multiple criteria from a table
  • Use INDIRECT and OFFSET with advanced string concatenation for the most automated lookups possible in Excel
  • Save hours of work every day by automating spreadsheets
View Curriculum
  • Microsoft Excel 2007 or later — Windows or Mac!



Created: June 2016


About This Course

So, you use Excel at work. And, you’ve got a handle on the basics. But you’ve got a feeling that if you just knew a little bit more about the program, you could be way more productive at work.

Unfortunately, it’s hard to figure out how to begin. Online forums and websites are crammed with confusing information, and there’s so much content out there that it’s tough to decide where to start.

Well, don’t worry — Deskbright is here to help! We’ve identified Excel’s most important features and bundled them into a series of engaging videos that make learning spreadsheets easy.

In this advanced course, we’ll cover lookups — some of Excel’s most powerful features. From common functions like VLOOKUP and HLOOKUP through more advanced formulas, we’ll cover everything you need to know to become a pro.

In this course, we'll follow a fictional company called SnackWorld as it uses Excel to extract valuable insights from its business data. All of our lessons are based on real-world uses of these functions, so you'll get to see live applications of everything you learn. You’ll get over an hour of easy-to-understand video, taught by master Excel instructor Sam McIntire. Plus, comprehensive exercises and answer keys to go along with every function you’ll learn — and a comprehensive culminating exercise to test your skills.

It’s time to stop wondering, and take your potential into your own hands. With a little bit of practice, you can make your work work look easy!

About The Instructor

This course is taught by master Excel instructor Sam McIntire of Deskbright. Through his website, Sam has helped thousands of students just like you learn the skills they need to thrive at work. Sam:

  • Has helped thousands of students learn the Excel formulas and functions they need to succeed at work;
  • Is an experienced management consultant who learned Excel on-the-job at a top tier firm;
  • Has received hundreds of positive reviews and 'thank you' e-mails from students whose work was transformed by his lessons.

Course Benefits

  • Succinct, to-the-point, and easy-to-follow videos that will help you learn Excel quickly and easily;
  • Advanced formulas used by professionals in top-tier consulting firms — now available to you!
  • Comprehensive exercises and answer keys to accompany every video, so that you can practice your skills as you learn;
  • A culminating, real-world exercise so that you can test your skills in a live business scenario.
Who is the target audience?
  • This course is for folks who have a baseline familiarity with Excel, but haven't yet had the chance to explore more powerful and advanced formulas and functions.
  • Intermediate Excel users should be able to dive into these lessons with no problem, but some familiarity with the program is a pre-requisite — including general knowledge of what a formula is and how it works; how to enter formulas into cells; absolute and relative cell references; and working with strings.
  • Towards the end of this course, we'll build on what we've learned to dive into some advanced lessons that will help even experienced Excel pros get the most out of their spreadsheets.
  • This course is recorded on a Windows computer, but the formulas and functions we use are also applicable to Excel for Mac
Students Who Viewed This Course Also Viewed
Curriculum For This Course
1 Lecture 01:37

Welcome to Deskbright's Advanced Excel Lookups course! This brief overview will explain the course format and show you all the exciting things you're about to learn.

Preview 01:37
Basic lookups
2 Lectures 12:23

Seen frequently in spreadsheets worldwide, VLOOKUP is the most basic of Excel's lookup functions. It will allow us to look up a value in a table based on a given index and lookup column.

Preview 07:37

VLOOKUP's lesser-known cousin HLOOKUP will allow you to perform lookups on a horizontal table rather than a vertical one.

Preview 04:46
Improving our lookups with INDEX MATCH
2 Lectures 14:05

INDEX MATCH is the lookup that we recommend using in most real-world Excel scenarios. It's actually a combination of two separate functions — INDEX and MATCH — which can be used together to work in almost any situation.


There's more to the MATCH function than just exact matches. We can also use 'greater than' or 'less than' matches to look up values based on custom-designed thresholds.

Different MATCH types
Advanced lookups
2 Lectures 14:37

INDEX MATCH isn't just for one-dimensional lookups. We can add another MATCH function onto our INDEX formula to look up based on a row and column at the same time.

Two-dimensional lookups

We can also use INDEX MATCH to look up a value or string based on multiple criteria rather than a single value. To do this, we'll have to leverage Excel's advanced array formulas.

Multi-criteria lookups
Helper functions
2 Lectures 15:22

INDIRECT is used to convert a string of text into a cell reference. This allows us to use string functions to create dynamic references to other sheets, tables, and workbooks.

The INDIRECT function

OFFSET is another function that can assist us with our lookups. It's used to displace a given range of data by a specified number of rows and columns, and can be used when looking up based on multiple tables.

Tying it all together
1 Lecture 00:57

It's time to test our lookup skills in the real world! The SnackWorld CEO wants you to create a customer information sheet to prepare her for high-priority sales calls.

Exercise: SnackWorld Customer List
About the Instructor
Sam McIntire
4.3 Average rating
33 Reviews
441 Students
1 Course
Master Excel Instructor and Founder of Deskbright

Sam McIntire is a master Excel instructor and founder of Deskbright, an online learning platform dedicated to helping people thrive at work. His internationally-known tutorials have helped tens of thousands of students around the world learn the Excel skills they need to succeed.

Sam started out as a management consultant, where he learned Excel on the job in one of the country's highest-performing firms.