Lookup at the same table

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.

Solved Solved
0 4 464
1 ACCEPTED SOLUTION

Ah, good question. Try this instead:

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

View solution in original post

4 REPLIES 4

Steve
Participant V

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.

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

Ah, good question. Try this instead:

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

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!!

Top Labels in this Space