Drop-down menu entered semi-automatic excel 2019 is it possible?

[AZOUTE]

Hello everyone,

Could I have help: I want to make a drop-down menu with semi-automatic entry but I am blocked by the FILTER function that unfortunately does not exist in Excel 2019 (I am on MAC and using the Excel 2019 version).
I would like to know if by using formulas, we can create an equivalent the FILTER function
Thanks in advance
AZOUTE

Classeur.xlsx
	E
2	#NAME?
Feuil1

Cell Formulas
Range	Formula
E2	E2	=FILTER(A2:A24,ISNUMBER(SEARCH(C2,A2:A24)),"Pas de résultat")

Cells with Data Validation
Cell	Allow	Criteria
D2	List	=_xlfn.ANCHORARRAY($E$2)
E2	Any value

 

[Peter_SSs]

Indeed, it works 5/5 !
Thank you very much.

You're welcome. Thanks for the confirmation. Glad we got there in the end.

 

[AZOUTE]

Thank you very much. I'm going to look at the formula to understand it well (you gave me a thread)

HI, Peter_SSs

I took a good look at the formula and I think I understood it well.
Is it necessary to put the discussion SOLVED, I am new to this forum and do not yet master the rules.
In any case, I learned a lot with you. Thank you again
Next...
AZOUTE

 

[Peter_SSs]

Is it necessary to put the discussion SOLVED, I am new to this forum and do not yet master the rules.

No, we don't mark threads as 'Solved' at MrExcel. The reason is that after the OP says their question is solved it often happens that somebody else comes along a bit later and provides an even better solution and we don't want to discourage that.

Instead, we have 'Mark as solution' where you can mark the post that best answers your question. This helps future readers looking at a similar problem. There is a link in my signature block below with more information about 'Mark as solution'.

In any case, I learned a lot with you. Thank you again
Next...
AZOUTE

You are very welcome.

.. and glad that you have worked through the formula logic. 9y)

 

[AZOUTE]

Instead, we have 'Mark as solution' where you can mark the post that best answers your question. This helps future readers looking at a similar problem. There is a link in my signature block below with more information about 'Mark as solution'.

OK, it's very well understood.

Thanks

 

[Peter_SSs]

Cheers.