Using LOOKUP() with an Enum value to match a value in a different table and return a column value

[jcfigueroav]

Using a LOOKUP() in a table/column/formula in order to search, match and return value from different column in a different table. I tried:
LOOKUP([model1_smpart], “dataMOLD”, “model1_smpart”, “acro_smpart”)
LOOKUP(TEXT([model1_smpart]), “dataMOLD”, “model1_smpart”, “acro_smpart”)
=LOOKUP(TEXT([model1_smpart]), “dataMOLD”, “model1_smpart”, “acro_smpart”)
where:
model1_smpart is a Enum type column in actual Table (Table A)
dataMOLD is the Table (Table B) where I search
model1_smpart is the column in the Table (Table B) I search
acro_smpart is the value to return from a different column in the Table (Table B) I search
Table A and Table B have columns with same names (like model1_smpart)

Every time that I test, it returns values only from the first row in Table B.

What am I doing wrong? Am I missing anything?

I found a post:
https://community.appsheet.com/t/im-using-the-lookup-expression-to-find-the-v/4376/3
where it is supposed to be fixed with TEXT() but in my case it does not.

Please help. Thank you.