1
Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)
1:09:27
2018-09-14
2
Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!
40:08
2017-11-08
3
Excel For Accountants: VLOOKUP & PivotTables Complete Lessons: Basic to Advanced: CWU Seminar
1:32:45
2017-01-12
4
Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples
26:04
2012-05-07
5
Excel & Business Math 33: VLOOKUP Function for Incentive Pay: Commissions & Piecework (15 Examples)
1:21:14
2018-02-25
6
Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP
33:41
2013-11-25
7
Excel Magic Trick 1134: IF or VLOOKUP function for Assigning Categories w/ Excel Formula 8 Examples
29:49
2014-07-29
8
Excel Magic Trick 1253: Can I Make VLOOKUP Use Column Headers? Yes: Use VLOOKUP & MATCH!
4:58
2016-01-08
9
Excel VLOOKUP Function - All You Need To Know
1:08:03
2012-03-26
10
Excel Basics #23: VLOOKUP function formula
8:14
2008-12-16
11
Highline Excel Class 07: VLOOKUP function formula 7 Examples
24:39
2009-04-01
12
Highline Excel Class 40: VLOOKUP 11 Unusual Examples
31:11
2009-05-24
13
Excel Magic Trick #128: VLOOKUP Categories
4:54
2008-10-17
14
Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH
8:34
2012-03-02
15
Excel Magic Trick 527: VLOOKUP 3rd Argument 4 Methods: Number, COLUMN, COLUMNS, MATCH
6:29
2010-02-24
16
Excel Magic Trick 836: VLOOKUP Lookup Value Not Matching Value in 1st Column (4 Examples)
8:30
2011-12-15
17
Excel Lookup Series #1: VLOOKUP Function 1st Example
7:58
2008-04-29
18
Excel Magic Trick 426: VLOOKUP to Assign Category To A Sales Number
1:58
2009-10-26
19
Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)
4:25
2009-09-25
20
Excel Lookup Series #2: VLOOKUP Function 2nd Example
6:41
2008-04-29
21
Excel Lookup Series #3: VLOOKUP Function 3rd Example
3:38
2008-04-29
22
Excel Magic Trick #5: Data Validation List & VLOOKUP
4:16
2008-03-03
23
Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets
8:56
2009-01-28
24
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria
7:52
2008-12-02
25
Excel Magic Trick # 155: VLOOKUP & TRIM function
4:25
2008-12-02
26
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
3:45
2008-10-28
27
Excel Magic Trick 303: VLOOKUP from middle of text-string
5:54
2009-04-04
28
Excel Magic Trick #193: Grade Book Based on Total Score
4:58
2009-01-09
29
Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH
6:13
2009-05-09
30
Excel Magic Trick #194: Grade Book Based on Percentages
10:16
2009-01-09
31
Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)
7:05
2009-05-09
32
Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble
4:11
2009-05-09
33
Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
9:08
2008-04-30
34
Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example
5:03
2008-04-30
35
Excel Lookup Series #5: VLOOKUP Function 5th Example
8:54
2008-04-30
36
YouTubersLoveExcel#28: Complex & Amazing Excel Trick
9:45
2008-06-07
37
YouTubersLoveExcel#27: Data Validation From Different Sheet
6:06
2008-06-06
38
Excel Name Trick #10: Store Lookup Tables in Memory
6:06
2008-06-13
39
Excel Name Trick #3: Names in Formulas and Functions
7:25
2008-06-13
40
YouTubersLoveExcel#46: VLOOKUP & Previous Bracket Trick
10:07
2008-06-27
41
YouTubersLoveExcel#47: VLOOKUP & 2 Cost Formulas
5:59
2008-06-27
42
YouTubersLoveExcel#48: VLOOKUP for TIME
7:38
2008-06-27
43
Excel Magic Trick #94: VLOOKUP Into Web Query
5:18
2008-07-01
44
YouTubersLoveExcel#52: VLOOKUP & Workbook References
7:38
2008-07-07
45
YouTubersLoveExcel#51: VLOOKUP & Variable Labels
6:10
2008-07-07
46
YTLE#62: VLOOKUP INDIRECT & Lookup in Different Tables
3:30
2008-07-18
47
YTLE#66: VLOOKUP replaces IF, Again!
3:06
2008-07-24
48
YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter
8:00
2008-07-24
49
YTLE#67: VLOOKUP & DGET functions
7:55
2008-07-28
50
YTL Excel #113: VLOOKUP RIGHT 5 characters only
2:55
2008-09-09
51
YTL Excel #112: VLOOKUP Problem (Sort Ascending)
3:22
2008-09-09
52
YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functions
10:34
2008-09-17
53
YTL Excel #129: Zip Code, VLOOKUP & TEXT functions
4:40
2008-09-17
54
Excel Magic Trick #111: Build A Questionnaire
8:02
2008-10-10
55
Excel Magic Trick #131: Ranking w MIN IF OFFSET
8:49
2008-10-17
56
Excel Magic Trick #129: More than 7 Nested IF functions
4:36
2008-10-17
57
Excel Magic Trick # 146 part 1: Dynamic List from Table #1
7:26
2008-11-19
58
Excel Magic Trick #146 part 2: Dynamic List from Table #1
8:18
2008-11-19
59
Excel Magic Trick #147: Dynamic List from Table #2
9:29
2008-11-19
60
Excel Magic Trick #154: Personal Budgets and VLOOKUP
7:40
2008-11-19
61
Excel Magic Trick # 159: VLOOKUP Duplicates 1st Column
3:59
2008-12-02
62
Excel Magic Trick #197: Grade Book with Weights
7:30
2009-01-09
63
Excel Magic Trick #196: Grade Book That Subtracts Two Lowest
7:58
2009-01-09
64
Excel Magic Trick #195: Grade Book That Subtracts Lowest Score
4:58
2009-01-09
65
Excel Magic Trick #206: Artists Commissions & VLOOKUP
4:01
2009-01-16
66
Excel Magic Trick 328: VLOOKUP Without 1st Column
9:39
2009-05-22
67
Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice
10:55
2009-06-03
68
Excel Magic Trick 355: VLOOKUP for Mortgage Calculator
6:55
2009-08-07
69
Excel Magic Trick 353: Date VLOOKUP for Seasons
5:01
2009-08-07
70
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
4:54
2009-10-08
71
Excel Magic Trick 408: VLOOKUP MIN Value
2:08
2009-10-14
72
Excel Magic Trick 409: VLOOKUP MAX Value, Return More Than 1 Record
10:13
2009-10-14
73
Excel Magic Trick 410: VLOOKUP: Convert Web Query Result 78.9k to 78,900
5:53
2009-10-14
74
Excel Magic Trick 420: VLOOKUP w SUM function in 3rd argument (Football Betting Table)
6:10
2009-10-19
75
Excel Magic Trick 436: VLOOKUP W 4 Lookup Columns
6:43
2009-11-02
76
Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)
8:01
2009-11-30
77
Excel Magic Trick 469: VLOOKUP for Horsepower Calculation
2:58
2010-01-01
78
Excel Magic Trick 488: VLOOKUP with 2 Lookup Values Return Table of Values & Track Down Errors
12:17
2010-01-29
79
Excel Magic Trick 508: VLOOKUP with Dynamic Table using OFFSET function
12:15
2010-02-17
80
Excel Magic Trick 509: VLOOKUP with Dynamic Table using Table Nomenclature
12:01
2010-02-17
81
Excel Magic Trick 555: IF & VLOOKUP Formula for Two Distinct Commission Calculations
3:04
2010-03-23
82
Excel Magic Trick 552: Display VLOOKUP Results Vertically
5:35
2010-03-23
83
Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table
6:56
2010-03-27
84
Excel Magic Trick 573: VLOOKUP & OR functions For Filtering Data With Categories of Criteria
4:49
2010-04-16
85
Excel Magic Trick 571: VLOOKUP To Create Form from Access Linked Data Import
9:06
2010-04-16
86
Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables
7:07
2010-05-03
87
Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked
5:25
2010-05-11
88
Excel Magic Trick 606: INDEX & MATCH Two Lookup Values
7:34
2010-05-20
89
Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template
12:28
2010-06-22
90
Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank
4:36
2010-07-12
91
Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set
4:46
2010-07-14
92
Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation
6:49
2010-07-28
93
Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP
3:56
2010-07-31
94
Excel Magic Trick 704: Analyzing Problem and Building Robust Solution.
13:08
2010-09-03
95
Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value
13:58
2010-09-03
96
Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells
6:35
2010-09-03
97
Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions
6:28
2010-09-27
98
Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables
7:24
2011-03-08
99
Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number
4:04
2011-04-01
100
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
7:23
2011-05-21
101
Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items
6:27
2011-09-06
102
Excel Magic Trick 870: VLOOKUP A Date and Pattern To Simplify Formula
2:31
2012-02-24
103
Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)
3:10
2012-02-29
104
Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)
3:10
2012-02-29
105
Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions
4:30
2012-03-15
106
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
4:55
2012-03-11
107
Excel Magic Trick 883: OR VLOOKUP? Lookup One Thing OR Another and Get Correct Record
9:42
2012-03-17
108
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
46:11
2012-03-27
109
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
1:09:43
2012-03-28
110
Approximate Match & Sorting To Reduce Exact Match Calculation Time VLOOKUP WEEK #4
13:17
2012-03-29
111
Excel Lookup Picture Approximate or Exact match (Excel VLOOKUP WEEK Video #6)
4:59
2012-03-30
112
CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)
37:46
2012-03-30
113
Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value
6:43
2012-05-15
114
Excel Magic Trick 928: VLOOKUP Grading: Plus, Minus or Zero: Looking Up A Plus, Minus or Zero
5:11
2012-06-19
115
Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ?
5:53
2012-06-22
116
Excel Magic Trick 969: VLOOKUP 2 Items From One Cell & Return 2 Items To Different Cell
7:10
2012-10-25
117
Excel Magic Trick 990: VLOOKUP returns Zero and #N/A, What To Do?
7:41
2013-05-05
118
Mr Excel & excelisfun Trick 131: Prevent VLOOKUP from Returning a Zero (4 Methods)
6:18
2013-07-11
119
Mr Excel & excelisfun Trick 143: EBAY VLOOKUP: Percentage or Max Amount
8:11
2013-10-10
120
Excel Magic Trick 1085: How To Simulate VLOOKUP Helper Column In Array Formula (Number or Text)
12:53
2014-03-16
121
Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR
2:52
2014-04-21
122
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
9:01
2014-05-05
123
Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)
12:20
2014-11-08
124
Excel Magic Trick 1150: Power Query: Dynamically Sum by Category without VLOOKUP Helper Column
6:24
2014-11-11
125
Excel Magic Trick 1170: VLOOKUP To Different Table In Each Column: CHOOSE & COLUMNS Functions
4:33
2015-01-13
126
Excel Magic Trick 1192: Match Lookup Value to Closest Number in 1st Column of Lookup Table
10:33
2015-04-24
127
Excel Magic Trick 1191: VLOOKUP: Lookup Temperature and Return to Bat Observation Table
4:44
2015-04-24
128
Excel Magic Trick 1194: VLOOKUP: Data Mismatch Makes Yields #N/A, What To Do?
2:40
2015-04-24
129
Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?
14:21
2015-08-24
130
Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1
8:42
2015-08-27
131
Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function
5:38
2015-08-29
132
Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range
8:46
2015-08-30
133
Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
10:45
2015-09-11
134
Basic Excel Business Analytics #08: Total Revenue Calculation: VLOOKUP or LOOKUP/SUMPRODUCT?
19:52
2015-09-24
135
Excel Magic Trick 1249: Build Database with Excel 2016 Table feature & VLOOKUP to Get Invoice Detail
25:46
2016-01-05
136
Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula?
8:02
2016-01-20
137
Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.
8:56
2016-01-22
138
Excel Magic Trick 1260: VLOOUP Returns Zero when Lookup Table Contains Empty Cell? 3 Fixes.
8:56
2016-01-22
139
Excel Magic Trick 1260 Re-Do: Prevent VLOOKUP from Returning Zero from Empty Cell in Lookup Table.
1:58
2016-01-22
140
Excel Magic Trick 1268: Excel 2016 Auto Detect Relationships: 2 Tables In PivotTable Field List
6:27
2016-02-01
141
Excel Magic Trick 1269: Excel 2016: Without Power Pivot: DAX Measures, Relationships & Data Model
10:09
2016-02-03
142
Excel Magic Trick 1274: VLOOKUP Replaces Long IF Formula for Conversion Formula (LOOKUP too)
6:09
2016-02-10
143
Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table
14:45
2016-03-13
144
Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick
10:40
2016-07-17
145
10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More
1:01:03
2016-08-24
146
Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?
15:52
2016-08-31
147
Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query?
11:46
2016-12-08
148
Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function
7:05
2017-01-29
149
Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)
55:04
2017-01-31
150
Excel Magic Trick 1428: VLOOKUP, COUNTIFS & IF Helper Column to Calculate Asset Current Value
7:03
2017-05-20
151
Excel Magic Trick 1431: XNPV, OFFSET & VLOOKUP to Get Dates & Cash Flows for NPV & IRR Calculations
13:37
2017-05-22
152
Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names
13:05
2017-08-28
153
Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!
36:47
2017-11-09
154
Mr Excel & excelisfun Trick 189: VLOOKUP for Missing Values in Column
9:06
2017-11-11
155
Excel & Business Math 35: VLOOKUP & MAX Functions for Percentage Method Federal Income Tax Deduction
29:36
2018-03-01
156
Excel Magic Trick 1479: Lookup Bulk Quantity Discount Prices Using VLOOKUP Function
10:54
2018-03-16
157
Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price
7:51
2018-03-22
158
Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too
11:39
2018-03-25
159
MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report
15:24
2018-10-06
160
VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)
9:57
2018-10-30
161
Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)
17:03
2018-11-07
162
VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?
7:56
2019-01-06
163
Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
7:09
2019-02-15
164
E-DAB 07: Data Modeling: VLOOKUP, Power Query or Power Pivot?
45:21
2019-03-16
165
Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND
7:46
2019-05-19
166
Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
21:48
2019-06-20
167
Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567
2:40
2019-07-18
168
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
25:02
2019-09-06
169
3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602
3:56
2019-09-14
170
Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601
4:14
2019-09-14
171
XLOOKUP or VLOOKUP & Dynamic Arrays to Deliver Table of Lookup Values! –- Excel Magic Trick 1611
1:50
2019-10-11
172
VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627
4:23
2019-12-19
173
Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.
9:00
2020-01-03
174
Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02
2:51
2020-01-29
175
Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643
8:55
2020-02-28
176
Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.
9:56
2020-09-21
177
XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.
5:20
2020-10-09
178
Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751
4:43
2021-08-31
179
VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
5:26
2021-10-05
180
VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760
4:33
2021-10-11
181
Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772
2:07
2022-01-14
182
Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773
2:48
2022-01-28
183
3 Unbelievable Excel Reporting Tricks for Monthly Employee Sales By Department. EMT 1779
11:33
2022-03-16
184
XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791
6:59
2022-04-21
185
Excel Formula to make First a 1, Second a 2, Third a 3, and so on. 6 Formula Examples. EMT 1797
4:04
2022-08-11
186
All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX – 28 Examples! - 365 MECS 08
1:18:51
2022-10-20
187
Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824
7:33
2023-07-06
