Download the featured file from this page https://www.bluepecantraining.com/create-a-searchable-drop-down-in-excel/ This video demonstrates how to create a searchable drop down list in Excel. Excel features and functions used include: Data Validation Name Manager SEARCH ISNUMBER IF MAX ROW INDEX MATCH OFFSET Please support this channel: Free Excel templates https://www.simplesheets.co/a/2147506566/v7Aj9zMx Recommended reading: Microsoft 365 Excel: The Only App That Matters by Mike Girvin https://amzn.to/3KQYM67 My landscape photos: https://www.photo4me.com/profile/chestertugwell/