Autofill value from drop-down-list source table

Example in attachment:
depending column value from drop-down-list source.ods

Copy in D2 =VLOOKUP(B2;'Drop down data'.$A$2:$B$13;2;0) then fill down.

See sample file edited.

Tested with LibreOffice (x64); OS: Windows 10.0.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.