Selecting a specific field based on a single select field

Topic Labels: Formulas
1923 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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”

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!

2 Replies 2

Use the SWITCH() function:

Captura de pantalla 2019-10-15_03-37-42_a. m..png

4 - Data Explorer
4 - Data Explorer

Thank you @Elias_Gomez_Sainz!