Auto-complete cell value when selecting another cell option (data validation)

user_5694362 0
Viewed 50

enter image description here

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".

vlookup array-formulas google-sheets-formula google-sheets arrays
1 Answers

use in E2:

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