July 2019

Create a Searchable Drop-down in Excel Using data validation you can create useful drop-down lists in Excel. If your list contains lots of values, it might be worth making it searchable. The video below explains how this can be done - no VBA required! Download the featured file here. https://www.youtube.com/watch?v=D6y8Rs0zUwo&t=65s Formulas used in the video…