Courses - Learn Excel Online By Doing

← Back to all Courses

Master Lookup Functions

ALL DO WATCH PRACTICE UNLOCKED

VLOOKUP() for Starters [07:54]

Learned Excel Functions: VLOOKUP()

VLOOKUP w. TRUE vs. FALSE [07:17] UNLOCK NOW

Learned Excel Functions: VLOOKUP()

VLOOKUP w. TRUE - applications [05:57] UNLOCK NOW

Learned Excel Functions: VLOOKUP()

HLOOKUP() vs. VLOOKUP() [02:46] UNLOCK NOW

Learned Excel Functions: HLOOKUP(), VLOOKUP()

Coffee Shop Price Table

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

Learned Excel Functions: FALSE(), HLOOKUP(), TRUE(), VLOOKUP()

Social Media Statistics UNLOCK NOW

Create some statistics to better understand the social media adoption

Learned Excel Functions: FALSE(), INDEX(), MATCH(), VLOOKUP()

Employee List UNLOCK NOW

Lookup employee information from the employee list based on different parameters

Learned Excel Functions: EOMONTH(), FALSE(), TODAY(), TRUE(), VLOOKUP(), WEEKNUM(), YEAR(), YEARFRAC()

Body Mass Index Calculation UNLOCK NOW

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

Learned Excel Functions: FALSE(), HLOOKUP(), IF(), IFERROR(), TRUE(), VLOOKUP()

Salesperson Ratings UNLOCK NOW

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

Learned Excel Functions: AVERAGEIF(), COUNTIF(), FALSE(), IF(), LEN(), SUMIF(), TRUE(), VLOOKUP()

Practice: VLOOKUP-I UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), VLOOKUP()

Practice: VLOOKUP-II UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), VLOOKUP()

Practice: VLOOKUP-III UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), VLOOKUP()

Practice: VLOOKUP-IV UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), VLOOKUP()

Practice: VLOOKUP-V UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), VLOOKUP()

Practice: HLOOKUP UNLOCK NOW

Making more practice by using lookup functions.

Learned Excel Functions: FALSE(), HLOOKUP()

Special Use of Lookups UNLOCK NOW

Try using vertical lookup instead of if statements

Learned Excel Functions: FALSE(), IF(), INDEX(), MATCH(), MAX(), TRUE(), VLOOKUP()

Beverage Sales UNLOCK NOW

Drill down your sales data using an alternative lookup method.

Learned Excel Functions: CONCATENATE(), INDEX(), MATCH(), OFFSET(), SUM()

Electronic Sales UNLOCK NOW

Using formulas for "Electronic Sales" operations.

Learned Excel Functions: FALSE(), INDEX(), MATCH(), PRODUCT(), SUM(), VLOOKUP()

Customer & Order Table UNLOCK NOW

Getting special information from the table.

Learned Excel Functions: EOMONTH(), FALSE(), RANK(), TRUE(), VLOOKUP()

IBAN Numbers UNLOCK NOW

Working on banking operations.

Learned Excel Functions: FALSE(), LEFT(), LEN(), MID(), RIGHT(), SUBSTITUTE(), TRUE(), VLOOKUP()

Win a lottary ticket UNLOCK NOW

Working with advanced functions.

Learned Excel Functions: CHOOSE(), FALSE(), IF(), INT(), ISNA(), RAND(), RANDBETWEEN(), RIGHT(), TRUE(), VALUE(), VLOOKUP()

Stoner UNLOCK NOW

Getting values with VLOOKUP:

Learned Excel Functions: DATE(), FALSE(), IF(), TODAY(), TRUE(), VLOOKUP()

Staff Data UNLOCK NOW

Getting some information with VLOOKUP on "Employee Data"

Learned Excel Functions: CONCATENATE(), FALSE(), ROUNDDOWN(), TODAY(), TRUE(), VLOOKUP(), YEARFRAC()

MATCH() - Basics [03:39] UNLOCK NOW

Learned Excel Functions: MATCH()

MATCH() match_type: -1 vs. 0 vs. 1 [03:48] UNLOCK NOW

Learned Excel Functions: MATCH()

2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH [05:55] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

2-D Lookup - VLOOKUP w. MATCH - Framework [01:18] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1 [03:50] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2 [02:22] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

2-D Lookup - VLOOKUP w. MATCH - Practice Exercise [06:14] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

2-D Lookup (Horizontal + Vertical) - HLOOKUP w. MATCH [06:50] UNLOCK NOW

Learned Excel Functions: HLOOKUP(), MATCH()

INDIRECT() - Basics [04:19]

Learned Excel Functions: INDIRECT()

INDIRECT() w. Range Naming - Applications [06:02] UNLOCK NOW

3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question [04:20] UNLOCK NOW

Learned Excel Functions: INDIRECT(), MATCH(), VLOOKUP()

3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer [07:11] UNLOCK NOW

Learned Excel Functions: MATCH(), VLOOKUP()

Reverse Lookup - Question [03:28] UNLOCK NOW

Reverse Lookup - INDEX() w. MATCH() - 1 of 2 [08:14] UNLOCK NOW

Learned Excel Functions: INDEX(), MATCH()

Reverse Lookup - INDEX() w. MATCH() - 2 of 2 [06:07] UNLOCK NOW

Learned Excel Functions: INDEX(), MATCH()

SUMIFS(): Conditional Summation (1 criteria) [04:29] UNLOCK NOW

Learned Excel Functions: SUMIFS()

SUMIFS(): Conditional Summation (2 criteria) [04:11] UNLOCK NOW

Learned Excel Functions: SUMIFS()

SUMIFS(): Conditional Summation (3 criteria) w. date range [05:20] UNLOCK NOW

Learned Excel Functions: SUMIFS()

SUMIFS(): Condition based Selective Cumulative Running Total [05:32] UNLOCK NOW

Learned Excel Functions: SUMIFS()

COUNTIFS() - Single/Multiple Criteria: Duplicate Count, Instance No. [06:10] UNLOCK NOW

Learned Excel Functions: COUNTIFS()

OFFSET() with MATCH() [15:11] UNLOCK NOW

Learned Excel Functions: MATCH(), OFFSET()

Level: Mastery
Exercises: 0/44
Steps: 0/162
Points: 28.550
Approx. Time: 9h 10m

Master Lookup Functions

Become a lookup ninja using all kinds of lookup of functions using them combined

Rating Count : 6