1
INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)
12:25
2019-11-15
2
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
1:09:39
2011-05-14
3
Highline Excel Class 43: MATCH function
6:43
2009-05-24
4
Highline Excel Class 44: Basics of INDEX & MATCH functions
16:36
2009-05-24
5
Highline Excel Class 45: INDEX function & MATCH function 12 Unusual Examples
39:08
2009-05-25
6
Excel Magic Trick # 283: Lookup Vendor Name With Low Bid
2:42
2009-03-06
7
Excel Magic Trick 163 Formula Return Descending Sorted List
7:12
2008-12-02
8
Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers
9:33
2010-01-12
9
Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations
14:42
2010-01-12
10
Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)
17:44
2010-01-05
11
YTLE#77: INDEX INDIRECT MATCH functions for Payroll
9:01
2008-07-30
12
Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists
8:08
2008-12-02
13
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
6:20
2009-03-06
14
Excel Magic Trick # 282: Lookup Name When Today Is Birthday
5:36
2009-03-06
15
Excel Magic Trick #225: 2 Way Lookup With Duplicates
5:51
2009-01-23
16
Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria
10:21
2008-12-02
17
Excel Magic Trick #148: Dynamic List from Table #3
10:32
2008-11-19
18
Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates
10:00
2008-11-19
19
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
3:45
2008-10-28
20
YouTubersLoveExcel#46: VLOOKUP & Previous Bracket Trick
10:07
2008-06-27
21
Excel Magic Trick #116: Find Best Poker Game
3:21
2008-10-10
22
Excel Magic Trick #117: Reverse 2-Way Lookup Part 1
9:16
2008-10-10
23
Excel Magic Trick #118: Reverse 2-Way Lookup Part 2
5:43
2008-10-11
24
Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit
5:20
2008-10-28
25
Excel MT 144 p1 Formula: Avoid Data Validation 1 Rule Limit
10:33
2008-10-28
26
Excel Magic Trick 297: Add Certain Column Only
8:53
2009-03-23
27
Excel Magic Trick 297.5: Conditional Sum for Varying Columns
7:25
2009-03-23
28
Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?
13:27
2009-04-24
29
Excel Magic Trick #119: Is Item In List? 2 Examples
4:29
2009-05-07
30
Excel Magic Trick 341 Extract Data w OFFSET & INDEX function
5:49
2009-06-22
31
Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook
14:39
2009-08-07
32
Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula
12:43
2009-08-13
33
Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula
8:20
2009-08-13
34
Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula
8:24
2009-08-13
35
Excel Magic Trick 364: Return First Non-Blank (Array Formula)
4:31
2009-08-13
36
Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)
5:17
2009-08-13
37
Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice
10:07
2009-08-13
38
Excel Magic Trick 423: INDEX Delivers Cell Reference - Sum Dynamic Range Without OFFSET Function
3:53
2009-10-26
39
Excel Magic Trick 538: Dynamic Sub Tables Based On Master Sheet Array Formula & Drilling Through
11:33
2010-03-05
40
Excel Magic Trick 606: INDEX & MATCH Two Lookup Values
7:34
2010-05-20
41
Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods
11:06
2010-05-24
42
Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free
13:54
2010-05-24
43
Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function
8:01
2010-07-17
44
Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail
12:12
2010-09-03
45
Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)
8:13
2010-09-03
46
Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution
7:18
2010-09-03
47
Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract
14:17
2010-09-03
48
Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter
23:32
2010-09-03
49
Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List
17:52
2010-09-03
50
Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function
6:21
2010-09-03
51
Excel Magic Trick 701: Take Table Of Values and Place In Column With Formula
7:20
2010-09-03
52
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
8:32
2010-12-26
53
Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions
15:06
2010-12-28
54
Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?
8:09
2010-12-28
55
Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending
15:03
2011-03-03
56
Mr Excel & excelisfun Trick 70: Lookup & Return Last 5 Numbers in a List
7:24
2011-03-11
57
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
7:23
2011-05-21
58
Excel Magic Trick 785: Extract Top 3 Customer Names With Formula (Robust Formula Handles Dups)
10:15
2011-05-21
59
Excel 2010 Magic Trick 789: Extract Records That Match Criteria for Multiple Reports Across Sheets
17:43
2011-06-06
60
Excel Magic Trick 802: Helper Column To Do Partial Text Lookup Formula To Return Multiple Records
7:40
2011-09-09
61
Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)
3:10
2012-02-29
62
Excel Magic Trick 875: Lookup Bond Score Based On Years and Rate: 2-Way Lookup With Rounding
15:18
2012-03-02
63
Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula
7:30
2012-04-02
64
Excel Magic Trick 899: Lookup Column of Data, Match Criterion, Display Items Vertically
8:31
2012-04-03
65
Excel Magic Trick 900: Simulate Filter With Formula to Create Immediate Filter Results
16:02
2012-04-03
66
Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)
6:58
2012-05-12
67
Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value
6:43
2012-05-15
68
Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup
6:05
2012-05-25
69
Excel Magic Trick 938: Lookup Row Associated With Employee And Get Last In That Row
10:26
2012-07-02
70
Excel Magic Trick 1005: Lookup nth Duplicate When Column With Lookup Value Is Not Sorted
7:50
2013-06-24
71
Excel Magic Trick 1004: Conditionally Format Row With nth Duplicate, Column Sorted or Not Sorted
6:53
2013-06-24
72
Excel Magic Trick 1003: Lookup nth Duplicate When Column With Lookup Value Is Sorted
2:30
2013-06-24
73
Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN
4:03
2013-07-13
74
Excel Magic Trick 1205: Rearrange Data with INDEX Function & Formula Number Incrementers
11:27
2015-06-06
75
Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP
10:45
2015-09-11
76
Basic Excel Business Analytics #09: Shortest Distance Shipping Costs: INDEX, MATCH, & IF Functions
10:58
2015-09-26
77
Excel Magic Trick 1254: Lookup Item Where 2 Values Are Closest: Helper Column or Array Formula?
8:55
2016-01-13
78
Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula?
8:02
2016-01-20
79
Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table
14:45
2016-03-13
80
Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test
9:16
2016-03-16
81
Excel Magic Trick 1295: TEXTJOIN & INDEX Function to create Random Description Codes
3:46
2016-03-21
82
Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items
7:11
2016-07-25
83
Excel Magic Trick 1313: Array Formula to Create Sorted Unique List in Cell. HUGE Formula. TEXTJOIN.
20:54
2016-08-10
84
Excel Magic Trick 1314: Array Formula To Create Sorted Unique List with Mixed Data
15:51
2016-08-17
85
Excel Magic Trick 1355 Extract Data at each Bold Font, Display Horizontally: GET.CELL Macro Function
25:26
2016-12-06
86
Excel Magic Trick 1370 INDEX Function & Number Incrementor Extract Items & Display In Every 3rd Cell
9:27
2017-01-19
87
Excel Magic Trick 1371: Excel Formula To Add Last Five Values in an Excel Table: INDEX Dynamic Range
7:28
2017-01-22
88
Excel Magic Trick 1373: Formula to Extract Every Nth Value & Conditionally Format Every Nth Value
12:54
2017-01-27
89
Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function
7:05
2017-01-29
90
Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
16:33
2017-03-16
91
Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item
5:13
2017-03-17
92
Excel Magic Trick 1425: Convert 2-Way Table to Single Column Table with INDEX & Number Incrementor
7:03
2017-05-18
93
Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values
12:09
2017-05-18
94
Excel Dynamic Arrays: Column of Records into Proper Data Set (Excel Magic Trick 1531)
6:46
2018-11-11
95
Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
7:09
2019-02-15
96
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
13:38
2019-05-31
97
Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568
2:32
2019-07-18
98
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
25:02
2019-09-06
99
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
25:02
2019-09-06
100
3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602
3:56
2019-09-14
101
Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601
4:14
2019-09-14
102
Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643
8:55
2020-02-28
103
Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.
6:47
2020-03-07
104
Append Multiple Columns with Excel Dynamic Spilled Array Formula. Excel Magic Trick 1646.
8:28
2020-03-13
105
Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648
5:28
2020-03-20
106
Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649
4:26
2020-03-21
107
Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.
5:03
2020-03-22
108
COUNTIFS 6 Criteria Counting Cross Tab Report. Change Cell Reference Every 3 Columns Too! EMT 1656
11:34
2020-03-29
109
Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
6:07
2020-06-29
110
Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.
9:56
2020-09-21
111
FREQUENCY Array Function for Quantitative Data. LET function to create full report! EMT 1693.
13:30
2020-10-05
112
XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.
5:20
2020-10-09
113
Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.
9:38
2020-10-13
114
Single Cell Spilled Reports with Dynamic Total Row & Formatting. Excel Magic Trick 1703.
24:50
2020-11-23
115
INDEX, LET & LAMBDA functions to Append Tables with Excel Formula. Advanced Array Formula. EMT 1712.
14:09
2021-01-05
116
Append Tables with Excel Formula: TEXTJOIN, FILTERXML, INDEX & SEQUENCE functions. EMT 1713
9:24
2021-01-06
117
Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
4:52
2021-01-13
118
INDEX & SEQUENCE functions to Spill a Constant Value Down Column. Excel Magic Trick 1718
3:32
2021-01-18
119
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
5:34
2021-03-01
120
Private video
—
121
11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
10:15
2021-07-20
122
INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.
2:09
2021-10-12
123
Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765
5:24
2021-11-22
124
Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824
7:33
2023-07-06
125
Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835
3:30
2023-08-22
126
Excel Magic Trick 1835 Part 02: Lookup ROW with CHOOSECOLS, INDEX, XLOOKUP or FILTER function?
4:17
2023-08-25
127
Dynamic Range in SUMIFS & SUMIF functions using XLOOKUP Function. Excel Magic Trick 1836
5:42
2023-08-27
128
BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871
6:54
2025-02-26
129
INDEX & MATCH: Simultaneous 2-Way Lookups into Accounting Trial Balance & Add Results. EMT 1888
3:42
2025-05-01
