Drop Down List ?

[coachdp3]

I have an array...B15:C30
Column B has names
Column C has initials

I would like a formula that would use a drop down list with each initial from column C and return the name(s) in column B when it matches the initial.

Example:

Drop Down List: MM

B C

John MM
Max IH
Sam MM
Trever RD

Answer Returned:
John
Sam

 

[AhoyNC]

Something like this?

Book1
	A	B	C
4
5		MM	John
6			Sam
7
8
9
10
11
12
13
14
15		John	MM
16		Max	IH
17		Sam	MM
18		Trever	RD
Sheet2

Cell Formulas
Range	Formula
C5	C5	=FILTER($B$15:$B$18,$C$15:$C$18=$B$5)

 

[coachdp3]

That worked great. I need to work with Filter more. Really cool. Thank you for your time.