Formula for Horizontal Lookup

[juanpa]

Is it possible to add an HLOOKUP formula in Appsheet?

If yes, could you send me an example?

Thanks in advance for your time.

[Austin_QREW]

Hi @juanpa ,

Here's some documentation on the LOOKUP() function in AppSheet. Also, using ANY(SELECT()) is another common to search for data in this way. 

LOOKUP() documentation

Hope this helps let me know if you have any other questions. 

Thanks!

Austin from AppSheet Training

 

Show More

LOOKUP()

Get column value from row in table or slice

Returns the value from the column of the matching row of a table or slice. It returns only a single column value, even if several rows match.

Sample usage

LOOKUP("Bob's Burgers", "Restaurants", "Name", "Phone") returns the value of the Phone column from a row in the Restaurants data set with a Name column value that matches Bob's Burgers. Equivalent to ANY(SELECT(Restaurants[Phone], ([Name] = "Bob's Burgers"))). See also: ANY(), SELECT()

LOOKUP([_THISROW], "Managers", "Location", "Name") from a location row, gets the name of a manager whose assigned location is the one identified by the current row. Equivalent to ANY(SELECT(Managers[Name], ([Location] = [_THISROW]))).

LOOKUP([_THISROW].[Order ID], "Orders", "Order ID", "Order Date")) from an order detail row, gets the order date from the parent order. Equivalent to ANY(SELECT(Orders[Order Date], ([Order ID] = [_THISROW].[Order ID]))) or [Order ID].[Order Date]].

Syntax

LOOKUP(value, dataset, column, return-column)

[Steve · Accepted solution]

Nope.