Playlist Duration

Playlist · Leila Gharani

Excel Lookup Formulas

by Leila Gharani · 21 videos

Total watch time

3h 53m

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

At an hour a day you'd finish in 4 days

The shape of the course

Each column is one video, to scale

15:10

WatchedTo watch

Compare Open on YouTube JSON

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 4 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 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. Titles open on YouTube in a new tab.

Videos to
Watched Leave out of the total
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 XLOOKUP in Excel (5 Practical 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
For your README

Embed a badge

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

Watch time: 3h 53m · 21 videos

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-11-08 (cached). Private or deleted videos are excluded from totals.