Learn VLOOKUP in Excel and get noticed!! | Pranay Suyash | Skillshare

## Learn VLOOKUP in Excel and get noticed!!

#### Pranay Suyash

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
7 Videos (30m)
• 01. Introduction

4:53
• 02. Excel functions

1:13
• 03. Excel Function structure: VLOOKUP Introduction

1:21
• 04. Understanding the VLOOKUP parameters

2:34
• 05. Practical use of VLOOKUP: Example 1

9:30
• 06. Practical use of VLOOKUP: Example 2

6:55
• 07. Practical use of VLOOKUP: Example 3 & Conclusion

3:18

In this class, we will be taking a look at the VLOOKUP function in Excel.

VLOOKUP is one of Excel's most used functions (just after maybe Autosum and a few other date functions). It is a lookup/ search function.

VLOOKUP can be used to:

1. Find if values exist

2. Comparison

In this course, you will grasp the structure of the lookup function and through multiple practical examples, covering most use cases, you will become a master in using the function (and maybe impress your boss ;))

I hope you find this topic useful. See you in the lessons.

You can also use the attached project file to follow along or practice later.

8

Students

--

Projects

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

#### Pranay Suyash

Pranay is a full-time business consultant and part-time art lover.

In his free time, he likes to pursue his hobbies in photo editing, photography, reading, and digital illustration.

See full profile

Report class