Excel Reverse Lookup

by excelisfun · 9 videos

Total watch time

1h 35m

at 1× speed · exactly 1 hour, 35 minutes, 10 seconds at 1×

custom

1×	1h 35m 10s
1.25×	1h 16m 8s
1.5×	1h 3m 27s
1.75×	54m 23s
2×	47m 35s

Average video10m 34s

Longest16m 42s

Shortest3m 24s

Compare Open on YouTube JSON

Plan to finish

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

Videos (9)

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

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


1	Excel Magic Trick 479: Reverse Two Way Lookup - Robust Formula for Duplicate Situations	14:42	2010-01-12
2	Excel Magic Trick 478: Reverse Two Way Lookup For Date and Time Column and Row Headers	9:33	2010-01-12
3	Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?	13:27	2009-04-24
4	Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates	9:03	2008-11-19
5	Excel Magic Trick 884: Reverse Lookup To Create Proper Data Set From Tabular Column / Row Table	16:42	2012-03-19
6	Excel Magic Trick 1291: Reverse Lookup Array Formula to Score Myers-Briggs Test	9:16	2016-03-16
7	Excel Magic Trick 1426: Lookup Row & Column Headers From 2-Way Lookup Table with Unique Values	12:09	2017-05-18
8	BYROW, BYCOL, TOROW, TOCOL, FILTER, IFS & OR Eta Functions Do Lookup Magic. Re-do EMT 1426. EMT 1871	6:54	2025-02-26
9	FILTER & XLOOKUP to Match One Column, Get All TRUEs in Column & Return All Row Headers. EMT 1874	3:24	2025-03-06

Embed a badge

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

Markdown

[![Watch time: 1h 35m · 9 videos](https://playlistduration.com/badge/playlist/PL8E044618F3A68AF3.svg)](https://playlistduration.com/playlist/PL8E044618F3A68AF3)

HTML

<a href="https://playlistduration.com/playlist/PL8E044618F3A68AF3"><img src="https://playlistduration.com/badge/playlist/PL8E044618F3A68AF3.svg" alt="Watch time: 1h 35m · 9 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/PL8E044618F3A68AF3 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.