Playlist · excelisfun
Why LOOKUP Function is Better Than XLOOKUP - 5 Videos
Total watch time
38m 12s
at 1× speed · exactly 38 minutes, 12 seconds at 1×
The shape of the course
Each column is one video, to scale
WatchedTo watch
Next time, skip the copying: change youtube.com to playlistduration.com in any playlist, video or channel address and it opens here. Or see the total on YouTube itself, with our extension for Chrome, Firefox or Edge.
Your plan
Plan to finish
About 1 day at an hour a day
Pick a daily pace and the days you'll watch. Ticked videos are skipped.
At one hour a day, every day, this playlist takes about 1 day. Turn on JavaScript to plan around your week.
How do I import this?
Google Calendar: in the left sidebar, + beside Other calendars → Import → pick the downloaded .ics → choose a calendar → Import. The same menu's From URL subscribes to the feed instead.
Apple Calendar (Mac): double-click the file or drag it onto Calendar → choose a calendar → Add all.
iPhone / iPad: open the file from Files, Mail or Safari's download bar → Add All → choose a calendar.
Outlook, Android, and subscribing instead of importing: step by step for every app →
Videos (9)
38m 12s in total · tick what you've watched
Tick videos you've watched — progress is saved in this browser. Titles open on YouTube in a new tab.
| Watched | Leave out of the total | ||||
|---|---|---|---|---|---|
| 1 | LOOKUP Beats XLOOKUP at Approximate Match for Discounts, Taxes, Commissions. EMT 1828 | 2:49 | 2023-07-20 | ||
| 2 | LOOKUP Function Can Do VLOOKUP or HLOOKUP, But Be Careful! EMT 1828 Part 2 | 3:03 | 2023-07-21 | ||
| 3 | Federal Income Tax Calculation: LOOKUP Function Beats VLOOKUP & XLOOKUP! EMT 1828 Part 3 | 3:05 | 2023-07-23 | ||
| 4 | LOOKUP Beats XLOOKUP For Single Cell Revenue Calculation. SUMPRODUCT Too! EMT 1829 | 3:34 | 2023-07-26 | ||
| 5 | LOOKUP Beats XLOOKUP For Horizontal / Vertical Lookup. Excel Magic Trick 1830 | 2:09 | 2023-07-29 | ||
| 6 | Multiple Discount Lookup Tables!?!? LOOKUP & SWITCH Come to The Rescue. Excel Magic Trick 1831 | 3:27 | 2023-08-01 | ||
| 7 | Multiple Discount Lookup Tables!?!? LOOKUP & FILTER Functions. Excel Magic Trick 1832 | 3:35 | 2023-08-04 | ||
| 8 | Excel Formula: Extract City Name from Description. Excel Magic Trick 1839 | 4:02 | 2023-10-04 | ||
| 9 | New Excel Cell Lists & Arrays & FLATTEN Change Everything. Model Building’s New Frontier. EMT 1926 | 12:28 | 2026-09-26 |
No videos match that filter.
For your README
Embed a badge
Show the watch time in a README or course description — it links back here and updates itself
[](https://playlistduration.com/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF)<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF.svg" alt="Watch time: 38m 12s · 9 videos" width="202" height="20"></a>Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.
Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF returns them as JSON — free, no key. API docs →
Data from the YouTube Data API as of 2026-11-07 (cached). Private or deleted videos are excluded from totals.