Excel Formula to Lookup Correct Price Based on Effective Date (6 videos)

by excelisfun · 7 videos

Total watch time

1h 9m

at 1× speed · exactly 1 hour, 8 minutes, 46 seconds at 1×

custom

1×	1h 8m 46s
1.25×	55m 1s
1.5×	45m 51s
1.75×	39m 18s
2×	34m 23s

Average video9m 49s

Longest13m 35s

Shortest4m 3s

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 (7)

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

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


1	Excel Magic Trick 1483: LOOKUP Array Formula: Lookup Correct Price Based on Effective Date	13:35	2018-04-18
2	Excel Magic Trick 1484: LOOKUP & Sorted Helper Column: Lookup Price Based on Effective Date	8:45	2018-04-20
3	Excel Magic Trick 1485: SUMIFS & MAXIFS Functions: Lookup Correct Price Based on Effective Date	9:32	2018-04-22
4	Excel Magic Trick 1486: VLOOKUP, MAXIFS, & Key: Lookup Correct Price Based on Effective Date	8:09	2018-04-26
5	Excel Magic Trick 1487: INDEX, MATCH & MAXIFS : Lookup Correct Price Based on Effective Date	13:03	2018-04-27
6	Excel Magic Trick 1491: “Lookup Latest Product Price” Survey Results, Winner of Free Book	4:03	2018-05-04
7	Excel Magic Trick 1481: Multiple Table Lookup: SWITCH or INDIRECT Function? VLOOKUP too	11:39	2018-03-25

Embed a badge

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

Markdown

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

HTML

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