Searchable dropdown lists are finally natively supported in Excel for Microsoft 365 (or will be soon, depending on your update schedule), eliminating the need for complex solutions like this. Still, it's a good exercise to strengthen understanding of the dynamic arrays logic.

You can learn more about (native) searchable dropdown lists in this post and video.