LOOKUP with wrong result

[bomexport_indus]

Hello,

I’m using LOOKUP expression in table named [PRODUCTS] to get a unique code from another table named [CUSTOMERS].

LOOKUP expression goes to the right Column which is CUSTOMER CODE but give me the wrong CUSTOMER CODE that refers to the PRODUCT CUSTOMER NAME i choose.

This is the expression i’m using :

LOOKUP([PRODUCT CUSTOMER NAME],“CUSTOMERS”,“PRODUCT CUSTOMER NAME”,“CUSTOMER CODE”)

• PRODUCT CUSTOMER NAME : is a column in table [PRODUCTS] where i’m using the LOOKUP expression
  CUSTOMERS : is the table where LOOKUP expression needs to get the right value from CUSTOMER CODE column

Please help me with that
Many thanks