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 6.4.7.2 (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 (
→ 
) to the left of the answer that solves your question.