playlistduration

VLOOKUP with Multiple Lookup Tables: Playlist of Videos

by excelisfun · 16 videos

Total watch time

4h 1m

at 1× speed · exactly 4 hours, 51 seconds at 1×

1×4h 51s
1.25×3h 12m 41s
1.5×2h 40m 34s
1.75×2h 17m 38s
2×2h 26s
Average video15m 3s
Longest1h 9m 27s
Shortest4m 26s
Compare Open on YouTube JSON

Plan to finish

About 5 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 5 days. Turn on JavaScript to plan around your week.

Videos (16)

4h 1m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Tick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names 13:05 2017-08-28
2 Excel Magic Trick 1316: VLOOKUP with Multiple Lookup Tables: IF, INDIRECT, SWITCH, IFS, or CHOOSE? 15:52 2016-08-31
3 Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function? 14:21 2015-08-24
4 Excel Magic Trick 1232: VLOOKUP to 36 Different Tables: Power Query Transforms 36 Tables Into 1 8:42 2015-08-27
5 Excel Magic Trick 1233: VLOOKUP to 36 Different Dynamic Tables: Table Feature & INDIRECT Function 5:38 2015-08-29
6 Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Range 8:46 2015-08-30
7 Excel Magic Trick 1293: Single Cell "Lookup Adding" w Proper Data Set for Myers-Briggs Test Score 6:24 2016-03-18
8 Excel Magic Trick 1306: Simulate VLOOKUP Helper Column In Array Formula using T(IF({1},Array) Trick 10:40 2016-07-17
9 Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too 11:39 2018-03-25
10 Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) 1:09:27 2018-09-14
11 Comprehensive Excel Dynamic Array Formula Lesson: The Power of Array Formulas (EMT 1516) 39:40 2018-10-20
12 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
13 Excel Magic Trick 1551: Lookup Discounted Price? 2 VLOOKUPs & ROUND 7:46 2019-05-19
14 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
15 Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648 5:28 2020-03-20
16 Create a Dynamic Lookup Table using INDEX & LOOKUP Functions. Excel Magic Trick 1649 4:26 2020-03-21

Embed a badge

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

Watch time: 4h 1m · 16 videos

Markdown
[![Watch time: 4h 1m · 16 videos](https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lP3hK6xearxD3F_GAUhLH7.svg)](https://playlistduration.com/playlist/PLrRPvpgDmw0lP3hK6xearxD3F_GAUhLH7)
HTML
<a href="https://playlistduration.com/playlist/PLrRPvpgDmw0lP3hK6xearxD3F_GAUhLH7"><img src="https://playlistduration.com/badge/playlist/PLrRPvpgDmw0lP3hK6xearxD3F_GAUhLH7.svg" alt="Watch time: 4h 1m · 16 videos" width="196" 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/PLrRPvpgDmw0lP3hK6xearxD3F_GAUhLH7 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.