# 36 VLOOKUP Tutorials Free Excel Training from SheetZoom

SheetZoom has 36 hands-on free VLOOKUP tutorials/trainings. Step by step learn how use VLOOKUP in Excel Online. This Excel training with VLOOKUP formula is free.

### Body Mass Index Calculation

Create a body mass index calculator using height and weight of a person

### Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

### Coffee Shop Price Table

Create an interactive price table for a coffee shop using various lookups. You'll learn base of VLOOKUP() and HLOOKUP() ...

### Customer & Order Table

Getting special information from the table.

### Customer & Order Table

Getting special information from the table.

### Electronic Sales

Using formulas for "Electronic Sales" operations.

### Employee List

Lookup employee information from the employee list based on different parameters

### Error Handling

Correcting value errors.

### Error Handling

Correcting value errors.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Good Biscuit

Understanding formulas with "Sales" operations.

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insight using rankings, basic statististics and conditional stat...

### IBAN Numbers

Working on banking operations.

### IBAN Numbers

Working on banking operations.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.

### My First Invoice

Creating an invoice with base functions.

### My First Invoice

Creating an invoice with base functions.

### Other Functions

Using some specific functions.

### Other Functions

Using some specific functions.

### Practice: VLOOKUP-I

Making more practice by using lookup functions.

### Practice: VLOOKUP-II

Making more practice by using lookup functions.

### Practice: VLOOKUP-III

Making more practice by using lookup functions.

### Practice: VLOOKUP-IV

Making more practice by using lookup functions.

### Practice: VLOOKUP-V

Making more practice by using lookup functions.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.

### Social Media Statistics

Create some statistics to better understand the social media adoption

### Social Security Numbers

Working on Social Security.

### Social Security Numbers

Working on Social Security.

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Special Use of Lookups

Try using vertical lookup instead of if statements

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Staff Data

Getting some information with VLOOKUP on "Employee Data"

### Stoner

Getting values with VLOOKUP:

### Stoner

Getting values with VLOOKUP:

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

### Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.

# Increase your efficiency, shine like an office star.

Sheetzoom is a revolutionary way to learn Excel in your browser or desktop
and it is fun, hands-on and teaches fast.

## Learn in Excel

All exercises are done using the actual Excel software covering all daily used formulas.

## No Software Needed

You don't need to have Excel installed, just login to the Sheetzoom.

## Real Life Examples

All exercises are done using the actual Excel software

## In Browser or Excel App

Available in browser or your Excel 2016 desktop application.