Lookup & Search Functions in Excel — 6h 7m total, 27 videos

1×	6h 6m 53s
1.25×	4h 53m 30s
1.5×	4h 4m 35s
1.75×	3h 29m 39s
2×	3h 3m 27s

Plan to finish

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

Videos (27)

6h 7m in total · tick what you've watched

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


1	Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup	6:20	2009-10-30
2	Excel Lookup/Search Tip 5 - Vlookup - Assign Values Instead of Errors to a Vlookup with IFERROR	5:18	2009-11-06
3	Excel Lookup/Search Tip 4 - Vlookup Explanation 3 - Vlookup to Assign Grades to Students	7:20	2009-11-06
4	Excel Lookup/Search Tip 3 - Vlookup Explanation 2 - Vlookup to Search an Employee Database	8:30	2009-11-06
5	Excel Lookup/Search Tip 2 - Vlookup Explanation 1 - Display Product Suppliers from a List/Database	9:08	2009-11-06
6	Excel Lookup/Search Tip 7 - Vlookup on Data that has a Prefix before it	4:38	2009-11-06
7	Excel Lookup/Search Tip 6 - Vlookup with a Drop Down Menu and Data Validation	5:49	2009-11-06
8	Excel Lookup & Search Tip 9 - Vlookup to Return Prices with Quantity Discounts for Orders in Excel	4:46	2009-11-16
9	Excel Lookup & Search Tip 8 - Vlookup with Lookup Values that Have Extra Values in the Cell in Excel	5:25	2009-11-16
10	Excel Vlookup Across Multiple Workbooks	5:58	2018-02-07
11	15 IF Statement Examples in Excel - Simple to Advanced - Workbook Included	21:57	2018-02-21
12	6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Included	25:10	2018-02-28
13	5 Bite-Size Vlookup Tricks for Excel - Workbook Included	12:59	2018-04-04
14	NEW VLOOKUP to Search All Worksheets Simultaneously in Excel	18:51	2018-08-21
15	Vlookup to Return 1st, 2nd, 3rd, Nth Matches from a List in Excel	25:15	2019-07-16
16	How to Use INDEX MATCH Lookups in Excel - Step by Step Guide	15:10	2019-07-23
17	Vlookup on Partial Matches in Excel	14:40	2020-05-19
18	Vlookup to Return All Matches in Excel	21:15	2020-05-26
19	Wildcard Vlookup to Return All Partial Matches in Excel	26:34	2020-06-02
20	Regular Expression Match Formula in Excel (No VBA) - Regex System Part 1	20:00	2020-06-23
21	FIND() vs SEARCH() Function in Excel	11:41	2020-07-28
22	VLOOKUP() Function in Excel - 3 Lessons to Get you Started!	19:10	2020-10-13
23	VLOOKUP() to Return the Min Max or Average Value in Excel	13:06	2020-10-20
24	Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface	26:47	2021-03-16
25	Vlookup Date Picker for Excel - Date Lookups	10:58	2021-06-29
26	Vlookup Date Picker for Excel - Dynamic Date Generation	19:33	2021-07-06
27	30 Second VLOOKUP() in Excel	0:35	2021-09-21

Embed a badge

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

Markdown

[![Watch time: 6h 7m · 27 videos](https://playlistduration.com/badge/playlist/PL901782550D047218.svg)](https://playlistduration.com/playlist/PL901782550D047218)

HTML

<a href="https://playlistduration.com/playlist/PL901782550D047218"><img src="https://playlistduration.com/badge/playlist/PL901782550D047218.svg" alt="Watch time: 6h 7m · 27 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/PL901782550D047218 returns them as JSON — free, no key. API docs →