This table also looks normalized. I’m confused. Which columns relate to your original question shown above?
How do I do VLOOKUP()?
In Excel, VLOOKUP() searches the first column in a range for a given search value and returns the value of another column in the same range from the row containing the matching value. The match can be exact or “approximate”. An approximate match is the closest value less than or equal to the search value.
VLOOKUP() with exact match
The AppSheet equivalent to VLOOKUP() using exact match is LOOKUP():
LOOKUP(searchvalue, "table", "searchcolumn", "resultcolumn")
where searchvalue
is an expression that produces the value to find; table
is the name of the table to search; searchcolumn
is the name of the column in which to look for the search value; and resultcolumn
is the name of the column whose value should be returned if the search value is found in the search column of that same row.
LOOKUP() returns at most only one value, from the first row in which it finds a match.
See also: LOOKUP()
VLOOKUP() with approximate match
AppSheet has no direct equivalent for VLOOKUP() with approximate match, but this expression provides similar behavior:
LOOKUP(
ANY(
ORDERBY(
FILTER(
"table",
([searchcolumn] <= searchvalue)
),
[searchcolumn],
TRUE
)
),
"table",
"keycolumn",
"resultcolumn"
)
where table
is the name of the table to search; searchcolumn
is the name of the column in which to look for the search value; searchvalue
is an expression that produces the value to find; keycolumn
is the name of the key column of the table; and resultcolumn
is the name of the column whose value should be returned if the value of the search column of that same row is less than or equal to the search term.
The expression above returns at most only one value, the value of the result column from the row with the highest search column value less than or equal to the search value.
Note that this expression is expensive and may hurt app performance.
Puedes por favor explicar la sintaxis de esta formula con un ejemplo ?

SUM(...)
sums the list of values (...
) produced by (2). 
SELECT(Orders[Total Amount], ...)
gathers a list of values from the Total Amount column of select rows (...
) in the Orders table. 
AND(...)
selects only those rows in the Orders table that match all of the given criteria (...
; see (3) & (4)). 
([Customer] = [_THISROW].[Customer])
selects only rows with a Customer column value that matches the Customer column value of the row receiving the SUM() result in (1). Rows that have the same customer. 
([Order Date] >= [_THISROW].[Order Date])
selects only those rows in the Orders table with an Order Date column value greater than or equal to the Order Date column value of the row receiving the SUM() result in (1). Orders on or after the given date.
Thanks!!!
Hi can I use this to:
get the value in row 1 col 1 and use that as the initial value of row 2 col 1?
Use case: I have 1 form where sometimes only 1 column is updated and the other columns of the form need to be filled with the previous row’s values for those columns.
Yep.
Thank you!
Hello,
I have tried to organize this list in alphabetical order and I have not succeeded, so I go to you to guide me to achieve it.
substitute(
SELECT(
registro alumnos[Nombre],
or(
([Categoria]=[IdPartidoLista].[_THISROW].[Categoria]),
([Categoria]=number([IdPartidoLista].[_THISROW].[Categoria])+1),
([Categoria]=number([IdPartidoLista].[_THISROW].[Categoria])1)
)
),
",",
"
"&
)
For your support, thank you.
what I have not been able to find is the correct syntax, can you guide me with this?
Thank you
SORT() accepts a List as an argument. SELECT() returns a List. Therefore:
SORT( SELECT(...) )
Thanks a lot for that @Steve
Was wondering how to set the location for a stocktaking app dependable from the user, worked like a charm!
Thanks again
HI
Help please with get result list
what I have
TEXT(LIST(SELECT(AllUsers[mail], ([userID] = [_THISROW].[ListIDs]), TRUE)  LIST("")))
Inside [ListIDs] = “user1 , user 3 , user 8 , user15 , user 21” it is text type in column or list in virtual column
The result of this formula gives the first address of the first user from the list (if he has an address).
I need to get result “user3@mail.test , user8@mail.test , user15@mail.test” text type.
Hi @Steve,
I have an issue and I have not been able to solve it, I hope you can help me …
I need to sort a related column by date in descending order.
Thanks