Master VLOOKUP function in 30 minutes

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

About This Class

25fa7a91

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).

VLOOKUP can be used to:

1. Find if values exist

2. Comparison

3. Linking multiple datasets

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.

1

Student

--

Projects

0

Reviews (0)

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