Why LOOKUP Function is Better Than XLOOKUP - 5 Videos

by excelisfun · 8 videos

Total watch time

25m 44s

at 1× speed · exactly 25 minutes, 44 seconds at 1×

custom

1×	25m 44s
1.25×	20m 35s
1.5×	17m 9s
1.75×	14m 42s
2×	12m 52s

Average video3m 13s

Longest4m 2s

Shortest2m 9s

Compare Open on YouTube JSON

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.

Videos (8)

25m 44s in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.


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

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Markdown

[![Watch time: 25m 44s · 8 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF)

HTML

<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0nm2uy-sTcymekaSPrr9cpF.svg" alt="Watch time: 25m 44s · 8 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-09-22 (cached). Private or deleted videos are excluded from totals.