2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1

• Beginner
• 250
• 250 points

2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2

• Beginner
• 250
• 250 points

2-D Lookup - VLOOKUP w. MATCH - Framework

• Beginner
• 250
• 250 points

2-D Lookup - VLOOKUP w. MATCH - Practice Exercise

• Beginner
• 250
• 250 points

2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH

• Beginner
• 250
• 250 points

3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer

• Beginner
• 250
• 250 points

3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question

• Beginner
• 250
• 250 points

Body Mass Index Calculation

• Intermediate
• 1800
• 1.800 points

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

Coffee Shop Price Table

• Unknown
• 900
• 900 points

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

Coffee Shop Price Table

• Unknown
• 900
• 900 points

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

Customer & Order Table

• Intermediate
• 1200
• 1.200 points

Getting special information from the table.

Customer & Order Table

• Intermediate
• 1200
• 1.200 points

Getting special information from the table.

Electronic Sales

• Advanced
• 1700
• 1.700 points

Using formulas for "Electronic Sales" operations.

Employee List

• Intermediate
• 1300
• 1.300 points

Lookup employee information from the employee list based on different parameters

Error Handling

• Advanced
• 1800
• 1.800 points

Correcting value errors.

Error Handling

• Advanced
• 1800
• 1.800 points

Correcting value errors.

Good Biscuit

• Intermediate
• 1400
• 1.400 points

Understanding formulas with "Sales" operations.

Good Biscuit

• Intermediate
• 1400
• 1.400 points

Understanding formulas with "Sales" operations.

Highest Paid Celebrities

• Intermediate
• 1300
• 1.300 points

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

Highest Paid Celebrities

• Intermediate
• 1300
• 1.300 points

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

HLOOKUP() vs. VLOOKUP()

• Beginner
• 250
• 250 points

IBAN Numbers

• Intermediate
• 500
• 500 points

Working on banking operations.

IBAN Numbers

• Intermediate
• 500
• 500 points

Working on banking operations.

iPhone vs Samsung

• Advanced
• 1200
• 1.200 points

Checking formulas results with Iphone-Samsung sales.

iPhone vs Samsung

• Advanced
• 1200
• 1.200 points

Checking formulas results with Iphone-Samsung sales.

My First Invoice

• Unknown
• 1600
• 1.600 points

Creating an invoice with base functions.

My First Invoice

• Unknown
• 1600
• 1.600 points

Creating an invoice with base functions.

Other Functions

• Intermediate
• 1000
• 1.000 points

Using some specific functions.

Other Functions

• Intermediate
• 1000
• 1.000 points

Using some specific functions.

Practice: VLOOKUP-I

• Advanced
• 1000
• 1.000 points

Making more practice by using lookup functions.

Practice: VLOOKUP-II

• Advanced
• 2000
• 2.000 points

Making more practice by using lookup functions.

Practice: VLOOKUP-III

• Advanced
• 1300
• 1.300 points

Making more practice by using lookup functions.

Practice: VLOOKUP-IV

• Advanced
• 200
• 200 points

Making more practice by using lookup functions.

Practice: VLOOKUP-V

• Advanced
• 200
• 200 points

Making more practice by using lookup functions.

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

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

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

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

Social Media Statistics

• Intermediate
• 1100
• 1.100 points

Create some statistics to better understand the social media adoption

Social Security Numbers

• Intermediate
• 1100
• 1.100 points

Working on Social Security.

Special Use of Lookups

• Intermediate
• 2400
• 2.400 points

Try using vertical lookup instead of if statements

Staff Data

• Advanced
• 1900
• 1.900 points

Getting some information with VLOOKUP on "Employee Data"

Staff Data

• Advanced
• 1900
• 1.900 points

Getting some information with VLOOKUP on "Employee Data"

Stoner

• Intermediate
• 1300
• 1.300 points

Getting values with VLOOKUP:

VLOOKUP w. TRUE - applications

• Beginner
• 250
• 250 points

VLOOKUP w. TRUE vs. FALSE

• Beginner
• 250
• 250 points

VLOOKUP() for Starters

• Beginner
• 250
• 250 points

Why VLOOKUP doesn't work?

• Intermediate
• 800
• 800 points

Resolving VLOOKUP errors.

Win a lottary ticket

• Advanced
• 1900
• 1.900 points

Working with advanced functions.