How to reference in 2D array

[Petar_Blazevic]

Hello,

i have 2D array in google sheet, like this:

Name          English         German

CheckIn.      text1                  text2

CheckOut.   Text3               Text4

And 2 enum list one with language other with name, how can i dinamiclly reference 2D table depending on this 2 enum

H

[Steve]

LOOKUP() - AppSheet Help

[Petar_Blazevic]

LOOKUP() is not working for me,  as return column has to be fixed.

I need to reference by row and b column 

[Steve]

What are you trying to accomplish? Localization?

[Petar_Blazevic]

Im trying to accomplish localization on message im sending to WhatsApp depending on language selection and message type selection. 

[Steve]

You'll need to do something like this:

SWITCH(
  USERSETTINGS("Language"),
  "English", [English],
  "German", [German],
  ""
)

[Petar_Blazevic]

I need "localization" not for app user but for customer receiving message/email

[Steve]

How is the app involved in the email? If the app generates the email, my suggestion applies. If the app doesn't generate the email then how does your question relate to AppSheet?

[Petar_Blazevic]

All has a Action button that when clicked send text message to whatsapp api to and open whatsapp client and there i just click to send.

I want to be able depending on dropdown language selection for specific guest be able to send message

Here is dropdown option for messenger

 action button for sending message

 

[Steve]

My suggestion applies, then.

[Petar_Blazevic]

I will check.

Question still remains how to make it work with 2 dropdowns. One for language and second CheckIn/CheckOut