Filter function dynamic array without pressing enter

%3CLINGO-SUB%20id%3D%22lingo-sub-2790803%22%20slang%3D%22en-US%22%3EFilter%20function%20dynamic%20array%20without%20pressing%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2790803%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I've%20created%20a%20searchable%20dropdown%20list%20in%20my%20excel%20sheet%20using%20the%20dynamic%20array%20FILTER%20function.%20Here's%20the%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DFILTER(klant%5BKlant%5D%2CISNUMBER(SEARCH(Pickorderinvoer!B4%2Cklant%5BKlant%5D%2C1))%2C%22nothing%20found%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20put%20in%20a%20search%20string%20I%20MUST%20press%20enter%20in%20order%20to%20get%20results.%20Is%20it%20possible%20to%20get%20a%20filtered%20result%20without%20pressing%20enter%3F%20I'm%20using%20a%20Mac%20and%20Excel%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2790803%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2792182%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20function%20dynamic%20array%20without%20pressing%20enter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792182%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1168492%22%20target%3D%22_blank%22%3E%40PieterStevense%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMore%20or%20less%20searchable%20drop-down%20list%20is%20in%20Excel%20for%20web%20so%20far%2C%20for%20the%20rest%20you%20shall%20use%20workarounds.%20With%20Enter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.

1 Reply

@PieterStevense 

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