1
Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples
1:18:34
2016-05-14
2
Excel VLOOKUP Function - All You Need To Know
1:08:03
2012-03-26
3
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
46:11
2012-03-27
4
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
1:09:43
2012-03-28
5
Approximate Match & Sorting To Reduce Exact Match Calculation Time VLOOKUP WEEK #4
13:17
2012-03-29
6
CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)
37:46
2012-03-30
7
Excel Lookup Picture Approximate or Exact match (Excel VLOOKUP WEEK Video #6)
4:59
2012-03-30
8
Highline Excel Class 07: VLOOKUP function formula 7 Examples
24:39
2009-04-01
9
Highline Excel Class 35: IF Function Vs. VLOOKUP Function
7:30
2009-05-13
10
Highline Excel Class 40: VLOOKUP 11 Unusual Examples
31:11
2009-05-24
11
Highline Excel Class 41: HLOOKUP ROWS Horizontal Lookup
2:47
2009-05-24
12
Highline Excel Class 10: VLOOKUP SUMIF & Percentage Increase
11:19
2009-04-01
13
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
1:09:39
2011-05-14
14
Highline Excel Class 42: Versatile LOOKUP function 10 Examples
23:02
2009-05-24
15
Highline Excel Class 43: MATCH function
6:43
2009-05-24
16
Highline Excel Class 44: Basics of INDEX & MATCH functions
16:36
2009-05-24
17
Highline Excel Class 45: INDEX function & MATCH function 12 Unusual Examples
39:08
2009-05-25
18
Highline Excel Class 46: CHOOSE function 4 Examples
10:01
2009-05-24
19
Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples).
9:44
2010-03-23
20
Excel Lookup Series #1: VLOOKUP Function 1st Example
7:58
2008-04-29
21
Excel Magic Trick #397: VLOOKUP Copied Down a Column (VLOOKUP Basics)
4:25
2009-09-25
22
Excel Lookup Series #2: VLOOKUP Function 2nd Example
6:41
2008-04-29
23
Excel Lookup Series #3: VLOOKUP Function 3rd Example
3:38
2008-04-29
24
Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Example
9:08
2008-04-30
25
Excel Lookup Series #4 PART 2: VLOOKUP Function 4th Example
5:03
2008-04-30
26
Excel Lookup Series #5: VLOOKUP Function 5th Example
8:54
2008-04-30
27
Excel Lookup Series #6: HLOOKUP Function
3:51
2008-04-30
28
Excel Lookup Series #7: LOOKUP Function
7:00
2008-04-30
29
Excel Lookup Series #8: MATCH Function
4:13
2008-04-30
30
Excel Lookup Series #9: INDEX function 1st Example
3:15
2008-04-30
31
Excel Lookup Series #10: INDEX function 2nd Example
3:57
2008-04-30
32
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
4:46
2008-04-30
33
Excel Lookup Series #12: INDEX & MATCH functions Example 2!
4:56
2008-05-01
34
Excel Lookup Series #13: INDEX & MATCH functions Example 3!
10:47
2008-05-01
35
Excel Lookup Series #14: CHOOSE function
3:47
2008-05-01
36
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
5:20
2008-06-13
37
YTL Excel #119: Amazing Lookup Solution! INDIRECT &SUBSTITUTE functions & Defined Names
6:28
2008-09-09
38
Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH
8:32
2010-12-26
39
Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables
7:24
2011-03-08
40
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
7:23
2011-05-21
41
Excel 2010 Magic Trick 800: Alter VLOOKUP Table To Simplify Formula To Return Multiple Items
6:27
2011-09-06
42
Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)
13:37
2011-10-25
43
Excel 2010 Magic Trick 821: 4-Way Lookup When There Are No Duplicates 2007 and 2003 Methods
9:35
2011-10-21
44
Excel Magic Trick 824: Two Way Lookup With More Than One Lookup Table Same or Different Sheets
24:28
2011-11-13
45
Excel Magic Trick 825: Variable Rate Tables: Commission, Piecework & Tax Examples
21:26
2011-11-13
46
Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions
4:30
2012-03-15
47
Excel Magic Trick 881: Lookup Picture with INDEX & MATCH functions instead of INDIRECT Function
4:55
2012-03-11
48
Excel Magic Trick 874: Lookup That Rounds To The Nearest Number (Increment Unequal) INDEX & MATCH
8:34
2012-03-02
49
Excel Magic Trick 875: Lookup Bond Score Based On Years and Rate: 2-Way Lookup With Rounding
15:18
2012-03-02
50
Excel Magic Trick 873: VLOOKUP - Lookup that rounds to the nearest number (Increment Equal)
3:10
2012-02-29
51
Excel Magic Trick 898: Lookup Row of Data and Display Items Vertically: INDEX INDEX Lookup Formula
7:30
2012-04-02
52
Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest Value
6:43
2012-05-15
53
Excel Magic Trick 922: Lookup Row, Then Lookup Value In Row & Return Column Header: Two Way Lookup
6:05
2012-05-25
54
Excel Magic Trick 942: Lookup Last Shipment Date For Customer, Sorted & Not Sorted Date Column
6:51
2012-07-06
55
Excel Magic Trick 984: Lookup Penultimate: Get Second To Last Item From Column Of Mixed Data
6:44
2013-01-10
56
Excel Magic Trick 983: Get Last Data For Employee From Across Many Sheets
8:09
2013-01-08
57
Excel Magic Trick 979: 2 Lookup Values in Lookup, Can't Have Helper Column.
7:27
2012-12-15
58
Excel Magic Trick 976: Excel Two Way Lookup - 11 Examples (2 Way Lookup)
18:30
2012-11-08
59
Excel Magic Trick 977: Lookup First Non Empty Cell In A Range, Lookup Last Number In A Range
6:50
2012-11-08
60
Excel Magic Trick 1001: Lookup Biggest Number After Partial Text Lookup, Many Duplicates
5:58
2013-06-13
61
Excel Magic Trick 1000: Lookup Last Partial Text Item using SEARCH and LOOKUP functions
4:09
2013-06-13
62
Excel Magic Trick 1009: Lookup 3 Different Arrays From 3 Different Tables: VLOOKUP, CHOOSE, INDEX
15:08
2013-06-27
63
Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables
10:08
2013-08-03
64
CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)
37:46
2012-03-30
65
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
1:09:43
2012-03-28
66
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
46:11
2012-03-27
67
Excel Magic Trick 1086: 3 Way Lookup Formula & Conditional Formatting, Date Criteria Mismatch
10:33
2014-03-27
68
Excel Magic Trick 1100: Cross Tabulated Lookup: 1) Lookup Row then match or 2) Array Multiplication?
14:11
2014-04-17
69
Excel Magic Trick 1102: VLOOKUP with Three Different Tables to Rank Movies, VLOOKUP & IFERROR
2:52
2014-04-21
70
Excel Magic Trick 1287: SWITCH Function: How to Lookup Formulas, References, or Anything Else
17:52
2016-03-05
71
Excel Magic Trick 1290: VLOOKUP to Multiple Dynamic Lookup Tables Listed as Single Downloaded Table
14:45
2016-03-13
72
Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score
6:24
2016-03-18
73
Excel Magic Trick 1294: Single Cell "Lookup Adding" w Improper Data Set to Score Myers-Briggs Test
7:10
2016-03-19
74
Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.
7:50
2016-05-16
75
Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP? Helper Column or Array Formula.
7:50
2016-05-16
76
Highline Excel 2016 Class 13: One Lookup Value to Return Multiple Items: INDEX & AGGREGATE
9:03
2016-05-17
77
Highline Excel 2016 Class 14: VLOOKUP as Relationship in Power Pivot Data Model & Vice Versa
8:02
2016-05-17
78
10 Amazing Excel Lookup Formulas for WAAT Accounting Seminar August 26, 2016, VLOOKUP & More
1:01:03
2016-08-24
79
Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE?
15:52
2016-08-31
80
Excel Magic Trick 1334: Power Query or Formula: Lookup Name Based on Max Value and more…
14:14
2016-10-25
81
Excel Magic Trick 1346: Array Formula: Split Master Table into Sub Tables, Each Product on New Sheet
22:05
2016-11-17
82
Excel Magic Trick 1348: Lookup Adding: Exact Match or Approximate Match (SUM Many VLOOKUPs)
13:32
2016-11-23
83
Excel Magic Trick 1352: Lookup 3 Items & Return to Single Cell VLOOKUP, INDEX or LOOKUP functions?
18:07
2016-11-30
84
Excel Magic Trick 1355 Extract Data at each Bold Font, Display Horizontally: GET.CELL Macro Function
25:26
2016-12-06
85
Excel Magic Trick 1356: Lookup 3 Items & Return to Single Cell Helper Column or Power Query?
11:46
2016-12-08
86
Excel Magic Trick 1359: Split Times Values Into 8 Equal Zones: VLOOKUP, LOOKUP or INT/HOUR?
17:10
2016-12-21
87
Excel Magic Trick 1374: Extract Only Total Row: VLOOKUP & Dynamic Range Created by INDEX Function
7:05
2017-01-29
88
Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)
55:04
2017-01-31
89
Excel Magic Trick 1377: Lookup Formula To List All Incomplete Assignments: INDEX, TEXTJOIN & More
18:52
2017-02-09
90
Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup
14:35
2017-03-10
91
Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell
11:00
2017-05-05
92
Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values
12:09
2017-05-18
93
Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names
13:05
2017-08-28
94
Excel Magic Trick 1480: VLOOKUP & MATCH Two-Way Lookup Quantity & Product to Get Price
7:51
2018-03-22
95
Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too
11:39
2018-03-25
96
Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too
11:39
2018-03-25
97
Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date
13:35
2018-04-18
98
Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date
8:45
2018-04-20
99
Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date
9:32
2018-04-22
100
Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date
8:09
2018-04-26
101
Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date
13:03
2018-04-27
102
Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price
8:56
2018-05-02
103
Excel Magic Trick 1489: 2 VLOOKUP in 1 Formula: Lookup Correct Volume Discount Product Price
8:56
2018-05-02
104
DAX Approximate Match Lookup & Exact Match Lookup Together for Discounted Product Price (EMT 1490)
20:02
2018-05-06
105
DAX Approximate Match Lookup Part 2: Foreign Key & Relationship or LOOKUPVALUE? EMT1492
13:03
2018-05-08
106
EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table
15:37
2018-05-12
107
Excel Magic Trick 1499: VLOOKUP or INDEX Joins to Create Transaction Description (3 Examples)
10:10
2018-05-29
108
Excel Magic Trick 1501: INDIRECT Function: Pull Data from Different Sheet Based on Row Number
5:49
2018-06-04
109
Excel Magic Trick 1501 Pt 02: INDIRECT Lookup Items From Different Sheets Based on Row Number
6:11
2018-06-07
110
Excel Magic Trick 1502: Lookup Based On Row Number with Data Validation For Row Number
8:21
2018-06-09
111
Excel Magic Trick 1504: Lookup Cell Address: 4 Examples: MATCH, ADDRESS, CELL function?
6:23
2018-06-11
112
Excel Magic Trick 1508: Lookup In Current Table? Self Join? VLOOKUP or Power Query?
8:43
2018-07-06
113
Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values
9:49
2018-07-20
114
Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514)
1:09:27
2018-09-14
115
VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521)
9:57
2018-10-30
116
Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529)
17:03
2018-11-07
117
VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?
7:56
2019-01-06
118
VLOOKUP To Get Complete Record: EMT 1532 Part 2: COLUMNS & Table Headers or FILTER Function?
7:56
2019-01-06
119
Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).
5:46
2019-02-12
120
Excel Magic Trick 1539: Extract Daily Sales Records With Formula. FILTER Function (Dynamic Array).
5:46
2019-02-12
121
Excel Magic Trick 1542: Lookup First Numbers Greater Than Hurdle & Less Than Hurdle!?!
7:09
2019-02-15
122
Excel Magic Trick 1543: MAXIFS & MINIFS to Lookup Numbers on Either Side of Hurdle
3:20
2019-02-16
123
Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND
7:46
2019-05-19
124
Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
21:48
2019-06-20
125
Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
21:48
2019-06-20
126
One Lookup Value, Return Multiple Items – The Easy Way with FILTER - Excel Magic Trick 1591
1:44
2019-08-19
127
Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600
25:02
2019-09-06
128
3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602
3:56
2019-09-14
129
Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601
4:14
2019-09-14
130
Excel Formula for Lookup Counting with COUNTIFS & SUM- Excel Magic Trick 1603
3:13
2019-09-18
131
Excel Formula for Lookup Adding with SUMIFS & SUM- Excel Magic Trick 1604
3:29
2019-09-19
132
INDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)
12:25
2019-11-15
133
VLOOKUP & LEFT Functions #N/A Error. And Lookup Code is in List?!? Excel Magic Trick 1627
4:23
2019-12-19
134
Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631.
9:00
2020-01-03
135
Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643
8:55
2020-02-28
136
Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.
6:47
2020-03-07
137
Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647
8:05
2020-03-17
138
Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648
5:28
2020-03-20
139
Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649
4:26
2020-03-21
140
Get Last 5 in Column, Then Add, Average & Display. Six Amazing Examples. Excel Magic Trick 1650.
5:03
2020-03-22
141
Lookup Top 3 for each Product. 4 Formula Examples. Excel Magic Trick 1665.
8:49
2020-05-05
142
Lookup 2nd Smallest Number. 2nd Biggest too. UNIQUE or FREQUENCY function? Excel Magic Trick 1672
6:38
2020-06-15
143
Multiple Text Modes with Excel Formula. Microsoft 365 Excel and Older Versions too. EMT 1674
6:07
2020-06-29
144
Sorted Frequency Distribution with the LET Function. Excel Magic Trick 1675.
6:01
2020-07-01
145
Compare Two Lists, Deliver Cell Address. Dueling Excel #194 with Mr Excel & Excelisfun
11:27
2020-09-04
146
Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691.
9:56
2020-09-21
147
XLOOKUP function to do Double LEFT Lookup! Excel Magic Trick 1694.
5:20
2020-10-09
148
Action Packed XLOOKUP Video: 3-Way Lookup, Cell Reference Lookup, Conditional Formatting. EMT 1695.
9:38
2020-10-13
149
OFFSET, XLOOKUP or FILTER function for Extracting Baseball Data? Excel Magic Trick 1697.
6:11
2020-10-25
150
Lookup Last Payment Date. 5 Methods for any version of Excel! Excel Magic Trick #1710
8:35
2020-12-22
151
Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
5:34
2021-03-01
152
Private video
—
153
Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731
6:10
2021-03-30
154
Advanced Lookup Formula to Show 3 Lowest Prices with Supplier Name, Including Ties. EMT 1737.
9:45
2021-05-24
155
11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT 1745
10:15
2021-07-20
156
Exact & Approximate Match Lookup Formulas in Power Query. 4 Amazing Formulas. Excel Magic Trick 1747
16:31
2021-08-03
157
Advanced Array Formula: FILTER or SUMPRODUCT to Simulate a Relationship Between Two Tables! EMT 1748
6:59
2021-08-10
158
Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751
4:43
2021-08-31
159
VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
5:26
2021-10-05
160
VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760
4:33
2021-10-11
161
INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.
2:09
2021-10-12
162
Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772
2:07
2022-01-14
163
Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773
2:48
2022-01-28
164
XLOOKUP Function, FILTER Function, VLOOKUP function and LOOKUP Function: Amazing Tricks! EMT 1791
6:59
2022-04-21
165
Excel Formula to Lookup Cell Address Of Max Value: 12 Amazing Examples. Excel Magic Trick 1794
9:55
2022-07-05
166
Excel Filter By Month: Filter feature or FILTER function? Amazing Dynamic Formula Solution. EMT 1796
7:50
2022-08-09
167
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
168
FILTER by 1 or More Lists in the Excel Worksheet: VSTACK or TOCOL? Excel Magic Trick 1799
4:41
2022-10-10
169
FILTER & XLOOKUP to Lookup Different Product Commission Rates for each Sales Rep. EMT 1801
3:24
2022-10-27
170
Two Way Lookup with XLOOKUP & Summary Report with SUMIFS. Excel Magic Trick 1802
3:28
2022-10-30
171
XLOOKUP Array Formula to Lookup Different Product Commission Rates for each Sales Rep. EMT 1804
3:29
2022-11-05
172
Spilled 2-Way Lookup Commission Report using LAMBDA and BYROW Functions. EMT 1803
5:22
2022-11-02
173
Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810
4:00
2023-01-05
174
Lookup Picture with Excel Formula – XLOOKUP or FILTER - Excel Magic Trick 1822
2:54
2023-06-29
175
Excel Formula To Randomly Lookup Pictures or Any Item. Excel Magic Trick 1823
2:53
2023-07-04
176
LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828
2:49
2023-07-20
177
LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2
3:03
2023-07-21
178
Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3
3:05
2023-07-23
179
LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829
3:34
2023-07-26
180
LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830
2:09
2023-07-29
181
Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831
3:27
2023-08-01
182
Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832
3:35
2023-08-04
183
XLOOKUP or VLOOKUP Based on Sheet Tabe Name!?! Excel Magic Trick 1833
4:36
2023-08-07
184
Lookup Column with CHOOSECOLS, INDEX or XLOOKUP function? Excel Magic Trick 1835
3:30
2023-08-22
185
Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866
11:30
2024-09-19
186
BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871
6:54
2025-02-26
187
FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874
3:24
2025-03-06
