Excel Searchable Drop Down Data Validation
Posted on 2013-11-12
On Sheet 1 I have a list of 8,000 company names in a standardized form (i.e. full name of company). Too many names for simple data validation.
On Sheet 2, I have 16,000 for sale listings that each typically include an incomplete partial company name. (each listing on its own row)
I would like to add a column to Sheet 2 that contains a searchable drop down list in a cell in every row that enables the user to enter the partial name in the listings and find all matching company names and then pick off the correct standardized name. (This will be a manual process by the data entry team and I want to make it as efficient as possible).
I have already done several google searches and can't find a solution that provides a searchable drop down in each row of Sheet2. I found one that came close, but couldn't get it to work in every row.
I'm hoping an Expert here will have the answer. As long as it works in every row of Sheet 2, I am open to any solution e.g. with or without controls, with or without VBA.
Thanks in advance!