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