How to assign weight to cells in OpenOffice Calc?

Question

excel

Tell me how to assign weight to cells in OpenOffice Calc (this is an analogue of Microsfot Excel)?
There is a drop-down list where you can select answer options, each answer has a digital weight from 1-5.
Question: Why am I a loser in Excel?
1) I'm too lazy to google (1 point)
2) I'm too lazy to read instructions (3 points)
3) I'm stupid (5 points)
4) I'm blondie (2 points)
And it is necessary that when answering, the score of the selected answer is displayed in the next cell.

Answer 1

In your case, I would choose the answer 1) I'm too lazy to google ...
Well, in essence:
1. Make a table of 2 columns: List - Weight
2. Put down the weight according to the list.
3. In the cell where the weight should be displayed, specify the VLOOKUP formula (analogous to VLOOKUP in Excel) with a reference to the cell in which the polled user selects the answer.
4. Profit_)))