Data Slice

[Alexander_Hanop]

Hi

Anyone knows what expression is equivalent to VLOOKUP in excel?

tks

[khuslid]

Look here:

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Alexander_Hanop]

Hi

tried cannot seem to find the right espression pic below to see the logic needed

[Aleksi]

Would you please describe what kind of filtering you are looking for so other community users are able to help you, thanks.

[Alexander_Hanop]

Sure need a slice from “main table” which contains rows with names filtered from “Select Names” Hope this helps if pic below is not clear enough

[Steve · Accepted solution]

The slice’s row filter expression would be something like this:

IN([Name], Select Names[Name])

See also:

help.appsheet.com

IN()

Is item in list?

[Alexander_Hanop]

Whoa! it works! tks Steve