Vlookup Date Picker for Excel - Date Lookups

Excel File: https://www.teachexcel.com/excel-tutorial/2454/vlookup-date-picker-in-excel-dynamic?nav=yt
Excel Courses: https://www.teachexcel.com/premium-courses/?src=youtube_v_1_rq6Mo-xUI

Make a dynamically updating vlookup date picker for excel that allows you to choose a date from three separate, but linked, drop down lists within the worksheet.

The days of each month will be accurate based on the year and month selected, even for February and leap years!

There will be 3 drop downs:
- Year
- Month
- Day

And each drop down list will update based on the current year and the month selection.

This tutorial combines: Vlookups, data validation, and complex custom formulas.

This part shows you how to build the vlookups that use a date as a lookup value.

(Note: DATEVALUE() should have been used to create the entire date for the vlookup in this video, like is done in the next video, but now you at least know multiple ways to do the same thing.)

Part 2: https://www.youtube.com/watch?v=a6uwFW6_YD4

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_1_rq6Mo-xUI
- Email Course: https://www.teachexcel.com/premium-courses/96/send-emails-from-excel-course?src=youtube_v_1_rq6Mo-xUI

Chapters:
0:00 What it Does
1:19 How it Works
1:56 Vlookups on Dates
3:18 Making Dates for Lookups
6:03 Vlookup Finalize
8:30 Vlookup Dynamic Column Refs

Additional Resources
Vlookups (msft): https://support.microsoft.com/en-us/office/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
Vlookup to Return All Matching Results: https://www.teachexcel.com/excel-tutorial/1933/vlookup-to-return-all-matching-results
Index/Match Lookups: https://www.teachexcel.com/excel-tutorial/2208/how-to-use-index-match-lookups-in-excel-step-by-step-guide
Data Validation in Excel: https://www.teachexcel.com/excel-tutorial/excel-data-validation-limit-what-a-user-can-enter-into-a-cell_1297.html
3 Ways to Automatically Update Drop Down Lists in Excel: https://www.teachexcel.com/excel-tutorial/2237/3-ways-to-automatically-update-drop-down-lists-in-excel-data-validation
Dates & Times in Excel (msft): https://support.microsoft.com/en-us/office/date-and-time-functions-reference-fd1b5961-c1ae-4677-be58-074152f97b81

TeachExcel.com

#msexcel #howto #tutorial

Видео Vlookup Date Picker for Excel - Date Lookups канала TeachExcel