in a spreadsheet, how can I insert variable outcomes in a cell?

I am trying to create a spreadsheet and at some point I need a cell to point to another cell with a list of variants, so as to have a random outcome (random variables 1 to 10)

How shall your “another cell” list the “variants”?. The standard should be that you make a selection from an array of “variants” given in a cell range with the help of the INDEX() function e.g.
Trying to use something like a semicolon separated list you will face a lot of problems due to the fact that LibO (like other spreadsheets) doesn’t offer a TEXTSPLIT() function.

Place your 10 items in cells A1:A10 one each, then the formula to pick a random item of those is