How to use the result of a formula as a reference?

[Rolando_Guerrieri]

I guess the switch function works when you have only a few possible values you need to transform into a reference. In my case it does not help.

The reason why and what I am trying to achieve is best explained in the framework of this discussion though

Dropdown Columns via a Lookup - How to change the order?

Currently by default if you create a drop-down column based on another table via ‘Lookup From Table’, the drop-down menu is in order of Row ID (essentially order of creation). Is there a way to change this? Simply changing the sort mode of the original table has no effect. In most scenarios you want the drop-down to be alphabetical for easy searching.