## Ultimate Excel Course #5 - Lookup Functions: The Powerful VLOOKUP Function and Beyond

#### Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
6 Videos (33m)
• Introduction

1:41
• The VLOOKUP Function Explained

11:14
• Using VLOOKUP for a Range Lookup

5:11
• Advanced VLOOKUP with a Dynamic Column Index Number

8:39
• A Versatile Lookup Formula - The INDEX and MATCH Combo

6:17
• Thank You

0:19

This class is #5 in a series called the Ultimate Excel Course.

In this class you will learn how to use Lookup Functions in Excel. From the powerful VLOOKUP Function and Beyond.

The VLOOKUP function is Excel's most well-known lookup function. It is often misunderstood and causes problems for Excel users.

This function is heavily used in business. It is often found linking data between sheets, comparing two lists or speeding up date entry and accuracy through lookup tables.

In this class VLOOKUP is explained inside-out. Two examples are demonstrated to get a feel for why this function is so important.

We don't stop there though. There is a lesson that demonstrates an advanced version of VLOOKUP by creating a dynamic column index number. And then we look at a more flexible alternative lookup formula.

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enrol and let's do this.

Please note that this is class #5 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

#### 12 of 12 students recommend

Alan obviously REALLY understands Excel, which means he can explain clearly exactly what each parameter in a function does.
Fantastic!
##### Michael Dean
Great class! Very clear explanation and examples of an extremely useful function.

54

Students

--

Projects

#### Alan Murray

IT Trainer, Coffee Lover and Lifelong learner

Hello, my name is Alan Murray and I have been training and consulting in Excel now for over 17 years. I have had the pleasure in helping individuals and businesses from all around the world improve their Excel skills.

I set up Computergaga about 8 years ago to help spread the latest Excel tips and to engage with other Excel experts and learners. It has grown beyond my expectations and I hope to get the chance to speak with many of you soon.

I have a real passion for Excel and I ...

See full profile