Bring unique data with data validation list

[Yaghoub61]

Hi all,


I have a list in D3. I need to change data validation list in D3,then I have the Results
Please without VBA & helper column
blue1.gif

Regards,
Jacob

[Pepe Le Mokko]

Post a sample sheet - see yellow banner - Thx

[Bo_Ry]

Please try at E2

=IFERROR(INDEX($B$2:$B$10,MATCH(1,ISNA(MATCH($B$2:$B$10,$D3:D3,))*($A$2:$A$10=$D$3),)),"")

or
=IFERROR(INDEX($B$1:$B$10,AGGREGATE(15,6,ROW($A$2:$A$10)/(MATCH($A$2:$A$10&$B$2:$B$10,$A$2:$A$10&$B$2:$B$10,)=ROW($A$2:$A$10)-ROW($A$1))/($A$2:$A$10=$D$3),COLUMNS($E3:E3))),"")