Excel Lookup Formulas

Total watch time

3h 53m

at 1× speed · exactly 3 hours, 52 minutes, 39 seconds at 1×

custom

1×	3h 52m 39s
1.25×	3h 6m 7s
1.5×	2h 35m 6s
1.75×	2h 12m 57s
2×	1h 56m 20s

Average video11m 5s

Longest15m 10s

Shortest3m 2s

Compare Open on YouTube JSON

Plan to finish

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

Videos (21)

3h 53m in total · tick what you've watched

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


1	Don’t Use VLOOKUP Until You Watch This! (VLOOKUP vs HLOOKUP Explained)	10:36	2017-03-04
2	How to use Excel Index Match (the right way)	11:32	2017-03-04
3	Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria	10:22	2017-03-09
4	Lookup Secrets in Excel: Easily Handle Upper & Lower Boundaries	11:40	2017-02-13
5	Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs	11:40	2017-03-28
6	Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header	8:02	2017-07-20
7	Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT	10:44	2017-08-17
8	Excel Formula Lookup Multiple Results: Return headers based on matrix values	13:37	2017-08-23
9	How to Solve Complex Lookup Problems in Excel with TEXTJOIN	12:22	2017-08-31
10	Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel	13:10	2017-11-17
11	Return Multiple Match Results in Excel (2 methods)	14:13	2018-08-30
12	VLOOKUP Explained: 2 Practical Examples to Master it in 10 Minutes	12:16	2018-09-13
13	How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates)	13:18	2019-03-14
14	Effortlessly LOOKUP ALL values between two dates (return many match results)	9:13	2019-06-13
15	How an Excel Pro Uses XLOOKUP (R.I.P. VLOOKUP & INDEX MATCH)	6:59	2019-09-12
16	How to do a Left Lookup in Excel with XLOOKUP (Made Easy)	3:02	2019-11-21
17	How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)	13:34	2019-11-28
18	Excel DGET Function Solves 2 of Your VLOOKUP Problems	11:18	2020-01-16
19	Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions)	12:51	2020-05-28
20	10 Excel Functions You NEED to KNOW as Engineers!	15:10	2021-12-23
21	Excel LOOKUP Values with Two Spreadsheets (Noob vs Pro)	7:00	2022-07-28

Embed a badge

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

Markdown

[![Watch time: 3h 53m · 21 videos](https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi.svg)](https://playlistduration.com/playlist/PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi)

HTML

<a href="https://playlistduration.com/playlist/PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi"><img src="https://playlistduration.com/badge/playlist/PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi.svg" alt="Watch time: 3h 53m · 21 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/PLmHVyfmcRKyxpMnh_KKfAgp5DF9ydawmi 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.