25 VLOOKUP Tutorials Free Excel Training from SheetZoom

SheetZoom has 25 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

Body Mass Index Calculation

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


Coffee Shop Price Table

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

Customer & Order Table

Getting special information from the table.


Electronic Sales

Electronic Sales

Using formulas for "Electronic Sales" operations.


Employee List

Employee List

Lookup employee information from the employee list based on different parameters


Error Handling

Error Handling

Correcting value errors.


Good Biscuit

Good Biscuit

Understanding formulas with "Sales" operations.


Highest Paid Celebrities

Highest Paid Celebrities

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


IBAN Numbers

IBAN Numbers

Working on banking operations.


iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


My First Invoice

My First Invoice

Creating an invoice with base functions.


Other Functions

Other Functions

Using some specific functions.


Practice: VLOOKUP-I

Practice: VLOOKUP-I

Making more practice by using lookup functions.


Practice: VLOOKUP-II

Practice: VLOOKUP-II

Making more practice by using lookup functions.


Practice: VLOOKUP-III

Practice: VLOOKUP-III

Making more practice by using lookup functions.


Practice: VLOOKUP-IV

Practice: VLOOKUP-IV

Making more practice by using lookup functions.


Practice: VLOOKUP-V

Practice: VLOOKUP-V

Making more practice by using lookup functions.


Salesperson Ratings

Salesperson Ratings

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


Social Media Statistics

Social Media Statistics

Create some statistics to better understand the social media adoption


Social Security Numbers

Social Security Numbers

Working on Social Security.


Special Use of Lookups

Special Use of Lookups

Try using vertical lookup instead of if statements


Staff Data

Staff Data

Getting some information with VLOOKUP on "Employee Data"


Stoner

Stoner

Getting values with VLOOKUP:


Why VLOOKUP doesn't work?

Why VLOOKUP doesn't work?

Resolving VLOOKUP errors.


Win a lottary ticket

Win a lottary ticket

Working with advanced functions.


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.

Start Learning Excel Now!

Join our club of happy learners and start your journey to become an Excel ninja!

;