Disclosure: when you buy through links on our site, we may earn an affiliate commission.

# Excel Lookup & Reference Functions for Beginners: VLOOKUP, XLOOKUP, and more in 35 minutes!

4.0
4.0/5
(7 reviews)
528 students

## 8.7

CourseMarks Score®

9.0

Freshness

7.4

Feedback

9.0

Content

Platform: Skillshare
Video: 36m
Language: English
Next start: On Demand

## Description

Learn Microsoft Excel lookup and reference functions in just 35 minutes!

What are lookup and reference functions?

Lookup and reference functions are Excel functions that allow you to search, join, and find information about data.

Why should you learn lookup and reference functions in Excel?

There’s a range of reasons why you should learn lookup and reference functions in Microsoft Excel as they’re useful for:

• Combining data sets
• Finding missing data values
• And more!

Many employers will even request knowledge of certain Excel lookup functions in job specifications and knowing how to use them will be useful for a range of tasks.

What will I know at the end of this class?

• How to use popular lookup and reference functions including VLOOKUP, XLOOKUP, and more!
• Best practices for using lookup and reference functions
• Strengths and weaknesses of different functions
• How to avoid mistakes and errors when using lookup and reference functions

Interested in learning more about Excel? Check out my other classes:

• Excel for Beginners: Learn The Essentials in 50 Minutes
• Excel Formulas You Need to Know in 30 Minutes
• Excel Pivot Tables for Beginners: Learn them in 20 Minutes
• Excel Text Functions: Learn them in 30 Minutes

#### You will learn

1. In the tab named ‘All Sales Data‘ enter a VLOOKUP formula in cell J2 to return the Total Sales from column F, then drag the formula down so all the Total Sales figures are entered in column J
2. Delete the Total Sales data you’ve just entered in column J, and now enter an XLOOKUP formula instead to return the Total Sales data in column J
3. Now go to the second tab named ‘Florida Sales Data‘, and enter a HLOOKUP formula to return the Q2 Sales value for Tampa in cell B10
4. Lastly, go to the third tab named ‘Race Times and enter an XLOOKUP formula in cell D11 using the ‘Exact match or next smaller item’ match mode to return the Prize, and drag the formula down so all three prize values are returned

#### Requirements

There is no prerequisite, anyone can begin this course.. This course is also great for beginners without any Business Analytics knowledge.

#### This course is for

This course is suitable for beginners.

#### Excel Classes

Excel teacher
Excel teacher
Browse all courses by on Coursemarks.
Platform: Skillshare
Video: 36m
Language: English
Next start: On Demand