Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Searchable Data Validation Dropdown List & XLOOKUP function – M365 Excel Magic Trick 1773

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1773.xlsx
Learn how to create a searchable data validation dropdown list in Microsoft 365 Excel. Learn how to use the XLOOKUP function to lookup a price from a Product Price Lookup Table.
Learn how to.
1. (00:00) Introduction
2. (00:14) Create a searchable data validation dropdown list in Microsoft 365 Excel
3. (00:51) Use the XLOOKUP function to lookup a price from a Product Price Lookup Table
4. (01:19) Use Searchable Dropdown list for exact match or contains match search
5. (02:14) Microsoft 365 Excel Remarks
6. (02:26) Closing and Video Links

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

ExcelIsFunSat, January 29, 2022 7:16am