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'll 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.

Requirements

No prior Microsoft Excel experience needed.

Description

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!

Overview

Section 1: IF Statement

Lecture 1 Introduction

Lecture 2 Example 1

Lecture 3 Example 2

Lecture 4 Example 3

Lecture 5 Example 4

Section 2: Vlookup

Lecture 6 Introduction

Lecture 7 Example 1

Lecture 8 Example 2

Lecture 9 Example 3

Section 3: Index Match

Lecture 10 Introduction

Lecture 11 Example 1

Lecture 12 Example 2

Lecture 13 Example 3

Beginner Excel users that need to understand the Vlookup, Index Match, and IF formulas.