Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel LOOKUP Functions
Instructions Manual
Manual
Self Assessment
Master Lookup Self Assessment Quiz
Excel lookup Case Studies- Please download for practice
Excel lookup Case Studies- Please download for practice
Master Lookup Functions Handbook
Master Lookup Functions Handbook
Lookups (1D, 2D, 3D, Reverse) & Conditional Calculations (Sum, Average, Count, Special Running Total)
1101 VLOOKUP() for Starters (7:51)
1102 VLOOKUP w. TRUE vs. FALSE (7:14)
1103 VLOOKUP w. TRUE - applications (5:59)
1104 HLOOKUP() vs. VLOOKUP() (2:44)
1105 MATCH() - Basics (3:37)
1106 MATCH() match_type -1 vs. 0 vs. 1 (3:45)
1107 2-D Lookup (Vertical + Horizontal) - VLOOKUP w. MATCH (5:51)
1108 2-D Lookup - VLOOKUP w. MATCH - Framework (1:18)
1109 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #1 (3:47)
1110 2-D Lookup - VLOOKUP w. MATCH - Common Mistake #2 (2:19)
1111 2-D Lookup - VLOOKUP w. MATCH - Practice Exercise (6:11)
1112 2-D Lookup (Horizontal + Vertical) - HLOOKUP w. MATCH (6:47)
1113 INDIRECT() - Basics (4:17)
1114 INDIRECT() w. Range Naming - Applications (5:59)
1115 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Question (4:17)
1116 3-D Lookup - VLOOKUP() w. MATCH() w. INDIRECT() - Answer (7:09)
1117 Reverse Lookup - Question (3:26)
1118 Reverse Lookup - INDEX() w. MATCH() - 1 of 2 (8:12)
1119 Reverse Lookup - INDEX() w. MATCH() - 2 of 2 (6:05)
1120 SUMIFS() Conditional Summation (1 criteria) (4:26)
1121 SUMIFS() Conditional Summation (2 criteria) (4:10)
1122 SUMIFS() Conditional Summation (3 criteria) w. date range (5:18)
1123 SUMIFS() Condition based Selective Cumulative Running Total (5:29)
1124 COUNTIFS() - SingleMultiple Criteria Duplicate Count, Instance No. (6:08)
Review our Course
COUNT() vs. COUNTA() vs. COUNTBLANK() vs. COUNTIFS() (3:19)
Master Lookup Self Assessment Quiz
Complete and Continue