Suppose I have a spreadsheet like this in libreoffice-calc:
Now I want to have a drop down list in
A3 to choose between the strings in
Text a) and
Text b) such that automatically cell
B3 contains the string from
Value a if
Text a is chosen and
Value b if
Text b is selected in my drop-down menu.
Is there any way to do this?