Complete Guide to Vlookup, Index Match, & IF Statement!

In-depth guide, with multiple examples, to learn everything about the Vlookup, Index Match, and IF formulas!

What you will learn

Basics of the Vlookup formula.

Basics of the Index Match formula.

Basics of the IF formula.

Real world examples of the Vlookup, Index Match, and IF formulas.


In this course, you will learn everything you need to know about the Vlookup, Index Match, and IF statement. In each section, you will learn one of the formulas listed above and there will be multiple examples to solidify your understanding. This is the one-stop location to learn the basic logic and lookup formulas!

Here are the reasons why you need to learn these formulas:

– The Vlookup and Index match formulas are used in almost all data analytics positions. These formulas alone will put you far ahead of the competition and, quite frankly, make your job way easier. Understanding lookup formulas is key to aggregating data efficiently and effectively.

– The IF statement is the bread and butter logic formula that provides the foundational understanding needed to dive deeper into programming and general logic. The if statement is used almost as much as the lookup formulas and, most of the time, in tandem with the lookup formulas.

This course will make you an absolute beast in all of these formulas. Join me in conquering these core formulas! You will not be disappointed and you will be well on your way to becoming an Excel expert! With just these three formulas, you will be able to do 95% of your job, and personal, tasks. Let’s do this!



IF Statement

Example 1
Example 2
Example 3
Example 4


Example 1
Example 2
Example 3

Index Match

Example 1
Example 2
Example 3

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock

Check Today's 30+ Free Courses on Telegram!