dropdown when lookup returns multiple values

[NaughtyPopz]

Hello,

i'm working on an employee excel file. I need to lookup a name and return it's ID number. But when i have 2 or more employee with the same name, i want the ID to return as a dropdown list.

Let's use this example.

I know how to use the index match formula, but can't seem to figure this one out.
Can anyone help me with that?

Thanks.

 

[Georgiboy]

Something like this:

Book1
	A	B	C	D	E	F
1	ID	Name			Name	ID
2	1	James			James	1
3	2	Frank				7
4	3	John
5	4	Mohammed
6	5	Mathilda
7	6	Amelia
8	7	James
9	8	Thomas
10	9	Eva
11	10	Franco
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=FILTER(A2:A11,B2:B11=E2)
Dynamic array formulas.