Index(Match())

[Gustavo_Eduardo]

Good afternoon. Does anyone know how to apply what in excel is known as Index(Match())?

[graham_howe · Accepted solution]

In Google Sheets it is also Index(Match( but if you're asking about AppSheet then I think you may not be understanding the way it work. AppSheet is primarily a database driven application and has a SQL-like expression language. So if you wanted to pull the value from the weight column for product ABC123 in a table of products, you would write something like this:

SELECT( Products[Weight], ([ProductCode] = "ABC123") )

It would probably be useful to refer to the following documentation

APP DESIGN

How to think about the design of your apps.

[Gustavo_Eduardo]

Te agradezco mucho Graham, la verdad es que yo no se codificar. Appsheet es una gran solución y ustedes acompañan a las personas. Saludos!