Filter function dynamic array without pressing enter

Occasional Visitor

Hi, I've created a searchable dropdown list in my excel sheet using the dynamic array FILTER function. Here's the formula:


=FILTER(klant[Klant],ISNUMBER(SEARCH(Pickorderinvoer!B4,klant[Klant],1)),"nothing found")


If I put in a search string I MUST press enter in order to get results. Is it possible to get a filtered result without pressing enter? I'm using a Mac and Excel 365.

2 Replies


More or less searchable drop-down list is in Excel for web so far, for the rest you shall use workarounds. With Enter.

Hi Sergei,

I have found a solution for this use case. Many thanks for your hints