Lookup at the same table

[Eloisio_Silva]

Hi,
How do I Lookup a value in a same table?Im using:

Lookup([Material],Products,Description,Price]
“Material” is a insulm that I am using in a product and both are at the “Products” table.

[Steve]

Your LOOKUP() expression should work so long as the Material column value of the current row matches the entire value of the Description column value of a row in the Products table. Note that the match must be complete (same length, same characters in the same order), but upper- and lowercase are considered equivalent.

[Eloisio_Silva]

this is ok but it doesn’t work.
is the syntax correct considering that the fields are in the same table?

[Steve · Accepted solution]

Ah, good question. Try this instead:

Lookup([_THISROW].[Material],Products,Description,Price)

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Eloisio_Silva]

Hello,
I´ve tried according to your suggestion and its working nice.
I stoped for I while and thats why I delayed to feed back.
Thanks!!