Online Excel Course: Lookup

Get instant access

Get access to Lookup now

Lookup: Course on lookup functions

‘Lookup’ is the perfect course for learning advanced lookup functions.

In just 59 minutes, you’ll know the exact steps to retrieve information across spreadsheets using lookup functions.

This is the quickest and best way to learn Excel’s most versatile functions.

  • 20 action-packed lessons
  • Project files to make your new knowledge stick
  • Free cheat sheet for easy repetition
  • (Re)view each lesson as many times as you’d like
  • Perfect for intermediate users
Get instant access

Course Curriculum

Here’s the complete list of modules and lessons ‘Lookup’ goes through.

  • Introduction to ‘Lookup’
  • What are lookup functions all about?
  • What is a lookup?
  • How to use VLOOKUP
  • How to use VLOOKUP with approximate match
  • How to use HLOOKUP
  • VLOOKUP vs. INDEX + MATCH
  • The MATCH function
  • The INDEX function
  • INDEX+MATCH – the theory behind
  • How to use INDEX+MATCH
  • VLOOKUP with multiple criteria
  • INDEX+MATCH with multiple criteria – the theory behind
  • Use INDEX+MATCH with multiple criteria
  • Typical errors with lookups
  • Error handling a lookup with IFERROR
  • Certificate
  • What now?

Who created this course?

Kasper Langmann (co-founder) created ‘Lookup’.

Kasper is also a certified Microsoft Office Specialist.

What’s unique about Spreadsheeto is, that the course creator is also the co-founder.

Kasper will not only be him you’ll listen to throughout the lessons – you’ll also be in direct contact with Kasper all throughout your Excel-journey.

“Hi, there! My name is Kasper and I’m the creator of ‘Lookup’. I’ve worked professionally with Microsoft Excel for the past 6 years. I’ve helped thousands of people just like you tap into the power of lookup functions. I’m also a certified Microsoft Office Specialist. I’m so ready to help you get awesome in Excel in no time!”
Kasper Langmann, Co-founder and course creator

Frequently asked questions

Got a question we don’t answer below? Then feel free to contact us.

Can I get a certificate of completion?

Absolutely! Once you’ve completed the course, you’ll get a certificate of completion. This applies not only to this course, ‘Lookup’, but all our courses.

Do I need any experience to take this course?

You need to know the basics of Excel to get the maximum out of this course. You should have experience using basic functions such as SUM. Most important of all, you should have ambition and motivation to level-up your Excel skills.

What version of Excel do I need?
This course is filmed in Microsoft Excel 2016 for Windows. If you have Excel 2010 (or later) for Windows, you’re perfectly capable of following along.

How long does it take to complete the course?

You can watch all the lessons in less than 1 hour. We’ve removed all the unnecessary and distilled Excel down to its most important elements. We highly suggest you also do the included exercises. We’ve included a cheat sheet that makes revising the course content smooth and easy. How quick you pick up the material is very different from person to person. Therefore, we recommend setting aside 2-3 hours to go through all lessons and exercises.

Get access to Lookup

Create a membership and get instant access to this course (and many others)

Lookup: Course on lookup functions
Get instant access