Searchable Dropdown Selection

[Jon3sy]

I have been attempting to create a searchable dropdown list for a form to search for names from a list of 465 names and have searched and watched/read multiple feeds but still can't get to what I need without using VBA. I followed through the example by Kevin Stratvert on youtube.com/watch?v=fsL57bvd7Pk and everything seems to work until I get to creating the dropdown from the transposed list. My list cannot just reference a single row that could have multiple options.

As an example, if I start typing a name beginning with "And", I want all the Andy's, Andrew's, Andrea's, etc to appear to select from.

My form only has 10 rows as it may need to have up to 10 different names selected for this section, but my lookup list has 465 individual people, so I want the list of names to filter as I type and narrow the selection.

We are using Office 365 and from what I can tell Version 2208 (Build15601.20660).

Hope someone can identify what I'm doing wrong.

Thanks in advance.

 

[Akuini]

but still can't get to what I need without using VBA.

If you're willing to use an add-in, you can try a free Excel add-in called "Search deList" to get a searchable combobox.
Technically, an Excel add-in uses vba, but by using an add-in you don't need to have the macro in your workbook, because the macro is in the add-in.

 

[Jon3sy]

My workplace doesn't allow us to access "add-ins" otherwise that was my first option.

 

[Akuini]

Ok, hopefully somebody will be able to help.

 

[Jon3sy]

Ok, hopefully somebody will be able to help.

thank you