On column "D" I used data validation to select data from column "A".
When I make a selection on column "D", I want column "E" to auto-complete with data from column "B".

CodePudding user response：

use in E2:

=INDEX(IFNA(VLOOKUP(D2:D; A:B; 2; 0)))