Refer to a column dynamically. So far and as far as I know, you can only refer to one column explicitly: SELECT(Translations[CA], ([Literal] = “Confirm”)) or LOOKUP(“Confirm”; “Translations”; “Literal”; “CA”) In this case and to understand the needs,...

Hi. I have the next expression: SELECT(“Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]”, Traduction[Text] = “Confirm”) The expression “Traduction[” & LOOKUP(USEREMAIL(), “Team”, “eMail”, “Language”) & “]” return Traduction[CA] i...