Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More (Udemy.com)

Master Microsoft Excel VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, XLOOKUP, XMATCH, Two-Dimensional Lookups & Data Validation

Created by: Robin Davis

Last updated October 2021

icon
What you will learn

  • How to use Excel lookup functions including VLOOKUP, HLOOKUP, INDEX-MATCH, LOOKUP, XLOOKUP, and XMATCH
  • How to add data validation to make your lookup projects more interactive and easier to use
  • How to correct the errors that most commonly arise when creating lookup formulas
  • How to create and use named ranges in lookup projects
  • How to create nested lookup functions
  • How to perform two-dimensional lookups

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews753#197 of 356 by number of reviews
  • Length1.6 hoursshorter than 88% of them
  • Last updatedOctober 2021earlier than 64% of them

icon
Course Description

As an Excel user you've probably heard a lot about VLOOKUP and other lookup functions. But what can lookup functions do, why should you use them, and how can they help you?

In essence, lookup functions search through data and return specific values. You may be asking yourself, “Well, why can’t I just do a manual search through my data with ctrl-f and find what I need that way?” And sure, that’s fine if you only need to look up one or two things. But what if you have ten, a hundred, or even thousands of things you have to search for and search through?

That’s where lookup functions come in, they are all about making Excel do the work for you. They can help you to quickly and efficiently retrieve data which saves you time and effort.

This course is a comprehensive deep dive into Excel’s lookup functions including (but certainly not limited to) the ever-popular VLOOKUP, my personal favorite, INDEX-MATCH, and the new function, XLOOKUP. It will give you a solid foundation of lookup function knowledge, but also challenge you to learn about and create nested and two-dimensional lookup functions that can really take your Excel capabilities to the next level.

In this course you'll get:

  • Detailed video walkthroughs so that you can feel confident about each step

  • Copies of all the files used in the course videos so that you can follow along and practice

  • Exercises that will challenge your understanding and deepen your lookup knowledge.

By the end of this course you’ll be able to confidently use lookup functions, perform two-dimensional lookups, create nested lookup functions, use data validation in your lookup projects, and know how to correct common errors, among many other things.

And while I hope that you love the course, Udemy has a 100% 30-day money back policy so you can try the course risk-free and can request a total refund if it's not meeting your expectations.

I'm so excited to teach this course because Excel lookup functions are my absolute favorite. There’s just something about seeing your data magically populate in cells because of a complex formula that you created that’s very satisfying - I can't wait for you to experience this for yourself and start loving lookup functions as much as I do. So check out one of the preview lectures for some free lookup function knowledge and a peek into my teaching style, or if you're ready to learn all you can about lookup functions right now click the "Buy now" button and I'll see you in there!



icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Robin Davis

Hello, I'm Robin. I specialize in creating instructional videos that are easy to understand and help users feel confident in their skills. l am passionate about teaching through video and have my own business, Redbird Tutorials, where I make software and web app tutorial videos for clients such as QuickBooks.

When it comes to Excel, I have over two decades experience using it in both corporate and government environments for companies such as Lockheed Martin, Amtrak, Loews Hotels, and the Maryland Transit Administration. I’m always so excited to share my Excel expertise with students because I know that having the right Excel skill set can vastly improve office productivity and efficiency.

I design my courses so that complex subjects feel approachable and I break down difficult concepts into smaller, digestible pieces so that they are easier to understand. Excel is complicated, but my course videos include multiple detailed examples and guided walkthroughs so that you feel supported every step of the way.

I want to see each of my students succeed and am here to help you in your Excel learning. You can contact me at any time with messages or questions.


icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.6

753 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Alys Suter on 3/25/2025

What a fantastic course with excellent resource workbooks! I always find it easier to learn by doing rather than just watching videos, and she made the experience engaging and interesting. Definitely 5 stars!

By Win Naing on 2/17/2024

The videos are very concise, get to the point without extra talking. The Excel formulas are demonstrated with good examples. The 1.5 hour lecture is very effective. It's an essential course for those who working with data lookup, search in spreadsheets.

By Aliza A on 1/15/2024

So far so great, loving the examples, access to work books and the explanations behind how a formula works. The transcript could be a bit more accurate wording wise as it sometimes shows words that isn't what the instructor said. A step by step book/document on how do all the formulas with pictures might be a great addition to add as it could be saved and used for later purposes.

By Paul Schneider on 9/1/2023

To give it five stars I do think a little more on this topic should have been covered, especially how to use the functions dialog boxes rather than to write out the formulas, this was a pretty big omission. Still it was a good course overall.

By David R. Smith Jr on 6/17/2023

Robin Davis is an Excellent instructor. This is the Best course that I have taken so far. She simplified and made very easy to understand Vlookup, Xlookup, Xmatch, Index-Match, etc. I highly recommend this course to others! Thank you Robin Davis!

By Wendy Contreras on 9/10/2020

The course is good, but the instructor hasn't answered a few questions in the Q/A. I had the same issue as other people and was looking around for a resolution, but have not seen a reply to them. The question header is: "Vlookup-indirect"

By Mark Kane on 8/30/2020

Plenty of practise examples to learn from, and you learn all the functions in an in a logical order making the course flow naturally. Well explained and in small enough chucks not to be overwhelming. Great course.

By Russell Gandy on 8/25/2020

This is an excellent course with some goods nuggets of information to maximize my Excel skills. The presentation is well done, yet seems to be highly scripted. So I needed to slow down the speed of presentation so that I had a chance to watch and listen at the same time.

By Leighanne Tucker on 8/18/2020

Great demonstrations and well explained formulas, having examples and exercises is useful as you learn excel by doing. Answers for Lecture 11 didn't appear to be corrected - only issue.

By Asim Zaeem on 6/11/2020

The Course is what it claims to deliver. I like the style that after every new concept, the instructor lets us practice the concept with the help of an exercise. This truly boosts learning. I would request the instructor to roll out her full Excel course. Her style of teaching really makes Excel learning easy and fun.

Showing all 10 reviews on CourseDuck

Read all 753 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100