Channel: ExcelIsFun

Category: Education

Tags: formulas and functionslookup product pricehighline collegemike girvinemtsearchable data validation dropdown listexcel is funexcel magicoffice 365excel functionscontains criteriaexcel funexcel magic trick 1773xlookup functionsearch dropdown listtype letters to open dropdowndropdownexcelopen dropdown listmicrosoft 365 excelexcel 365excel formulasemt 1773data validation dropdown listexcelisfundata validation makes lookup better

Description: Download Excel File: 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