Selecting a specific field based on a single select field

Hi Guys,

I am working on a formula/solution that gives me the result from a specific field. Maybe you can help me.

So my first field is a single select field with the following possible selections:

-“Lookup 1 selector”
-“Lookup 2 selector”
-“Lookup 3 selector”
-etc.

This is then followed by multiple lookup fields that look up data from different tables:

Lookup 1, Lookup 2, Lookup 3, etc.

I now want to create an additional final result field that contains the value of the Lookup field that has been selected with the selector.

And to make it more complicated: I am trying to avoid a long IF() formula because I might be adding more columns and selectors at a later stage. The goal is that I do not have to touch the formula of the final result field ever again. If I do have to touch it again, it should be a simple one like a sum or multiplication without any nestling.

Do you have any good ideas how to do it? Thank you in advance!

Use the SWITCH() function:

2 Likes

Thank you @Elias_Gomez_Sainz!

1 Like