Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

The FREE List Search Add-in Excel Campus allows you to quickly search a drop-down validation list (in-cell drop-down menu) in Excel. You can also search lists that do not contain validation.

DOWNLOAD Link: https://www.excelcampus.com/list-search

I just published the following feature updates for List Search.

1. Added Auto Open feature to automatically open the form when a cell that contains data validation is selected. This option can be toggled on/off with a toggle button in the options menu.

2. The add-in now works with data validation created by formulas (OFFSET & INDEX) and comma separated lists. It should work with all types of data validation lists.

3. Updated Escape Key behavior. If there is text in the search box, then Escape clears the search box. If the search box is empty, then Escape closes the form.


You can learn more and download the add-in at the following link.
https://www.excelcampus.com/list-search

Here is a video overview of the List Search Add-in: https://www.youtube.com/watch?v=kntHn2J7pdk

Here is the video of the November 2016 Update for List Search:
https://youtu.be/C-2mfmcozro

Here is the link to the article and video on how to add the drop-down icons next to the cells that contain data validation.
https://www.excelcampus.com/tips/drop-list-arrow-always-visible/
00:00 Introduction
01:30 Auto Open Feature
02:53 Data Validation Sources
03:59 Escape Key