playlistduration

Excel Two Lookup Values: VLOOKUP or INDEX and MATCH Functions.

by excelisfun · 31 videos

Total watch time

5h 47m

at 1× speed · exactly 5 hours, 47 minutes, 16 seconds at 1×

1×5h 47m 16s
1.25×4h 37m 49s
1.5×3h 51m 31s
1.75×3h 18m 26s
2×2h 53m 38s
Average video11m 12s
Longest1h 9m 43s
Shortest1m 10s
Compare Open on YouTube JSON

Plan to finish

About 6 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 6 days. Turn on JavaScript to plan around your week.

Videos (31)

5h 47m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Trick 1259: Can VLOOKUP Lookup Duplicates? Yes! Helper Column or Array Formula? 8:02 2016-01-20
2 VLOOKUP: Step Aside! New Epic Lookup Function = FILTER Dynamic Array Function (EMT 1521) 9:57 2018-10-30
3 Excel Dynamic Arrays: FILTER Array Function AND & OR Logical Tests (Excel Magic Trick 1529) 17:03 2018-11-07
4 Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods) 13:14 2015-02-27
5 INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3) 1:09:43 2012-03-28
6 Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula 12:43 2009-08-13
7 Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula 8:20 2009-08-13
8 Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula 8:24 2009-08-13
9 Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values 4:54 2009-10-08
10 Excel Magic Trick 1235: 2-Way Lookup For Currency Conversion: Don’t Use IF, Use INDEX or VLOOKUP 10:45 2015-09-11
11 Excel Magic Trick 1305: Adding Multiple Two-Way Lookups INDEX function & N(IF(1,Array) Trick 7:12 2016-07-17
12 Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values 9:49 2018-07-20
13 Excel Magic Trick 1510: Conditional Format Row With Duplicates Based on Product & Color 9:21 2018-08-05
14 Mysteries of VLOOKUP Function Revealed! 15 Amazing Examples! (Excel Magic Trick 1514) 1:09:27 2018-09-14
15 Excel Two Way Lookup with INDEX & MATCH Functions - Excel Magic Trick 1568 2:32 2019-07-18
16 Excel Two Way Lookup with VLOOKUP & MATCH Functions - Excel Magic Trick 1567 2:40 2019-07-18
17 Excel Intersection Operator, An Excel Party Trick? - Excel Magic Trick 1570 1:10 2019-07-19
18 Excel’s # 1 Silliest Formula: INDEX or INDIRECT? Excel Magic Trick 1571 (Two Way Lookup Trick) 4:41 2019-07-21
19 Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572 4:39 2019-07-22
20 Excel Conditional Format Row, Column & Intersecting Cell - Excel Magic Trick 1572 4:39 2019-07-22
21 Two Lookup Values for Excel Lookup? FILTER or INDEX? - Excel Magic Trick 1590 2:07 2019-08-17
22 Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600 25:02 2019-09-06
23 3-Way Lookup Adding: XLOOKUP or INDEX inside SUMIFS? –- Excel Magic Trick 1602 3:56 2019-09-14
24 Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601 4:14 2019-09-14
25 Two Lookup Values for VLOOKUP? See 5 Examples. Which is Your Favorite? Excel Magic Trick 1631. 9:00 2020-01-03
26 Which Lookup Formula is Fastest? Excel Magic Trick 1631 Part 02 2:51 2020-01-29
27 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751 4:43 2021-08-31
28 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758 5:26 2021-10-05
29 VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760 4:33 2021-10-11
30 INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2. 2:09 2021-10-12
31 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810 4:00 2023-01-05

Embed a badge

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

Watch time: 5h 47m · 31 videos

Markdown
[![Watch time: 5h 47m · 31 videos](https://playlistduration.com/badge/playlist/PL60BF5E550E6FF8D4.svg)](https://playlistduration.com/playlist/PL60BF5E550E6FF8D4)
HTML
<a href="https://playlistduration.com/playlist/PL60BF5E550E6FF8D4"><img src="https://playlistduration.com/badge/playlist/PL60BF5E550E6FF8D4.svg" alt="Watch time: 5h 47m · 31 videos" width="203" 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/PL60BF5E550E6FF8D4 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.