Searchable drop-down lists, no VBA

Hi all -

I have a sheet with multiple columns utilizing data validation drop-downs. I need the drop-downs to be searchable due to the large number of options in the drop-down lists (Country column for example). I understand there are limitations with data validation and this can be done with Comboboxes. Unfortunately, I am unable to email Macro-Enabled workbooks so Comboboxes are a no-go. Is there some kind of workaround to solve this?

Really hoping one of you excel guru's can help!! Thanks everyone in advance.

Hi Richard,

Thank you for your quick reply! I'm such a newbie I honestly didn't even know I could attach the workbook. To answer your first question, I don't have that many values. The most I will have is probably 200/250. Still enough that the users of the workbook don't want to scroll through them and have asked for a solution to make the drop-downs 'searchable'.

The attached workbook has been 'slimmed' down to simply contain two examples of drop-downs that are used.

Thanks again!

Thanks Richard!

Yes, VBA won't work because I need to be able to email this workbook and our IT department prohibits emailing Macro-Enabled workbooks.

In your example, is there a way to have the 'searchable' cells be on the 'QRR Form' tab vs. at the bottom of the list of values on the 'Drop Down Tables' tab like they are now? Or is that why it works because it's directly below all of the values? If that's the case, I don't think that's going to work.