how to get data from list

[R0CKY]

hi all
if I change in D2 the list in E2 Not give what on the list A
thanks.

[Phuocam]

Try this in E3:

=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$18=$D$2,ROW($B$2:$B$18)),ROWS($E$3:E3))),"")

Enter with Ctrl+Shift+Enter.

[R0CKY]

This works perfectly, thank you so much!

[Phuocam]

You're welcome!