Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

LOOKUPVALUE does not return all values

Hello to all   This is in fact a strange one (or not): I'm using LOOKUPVALUE with the following data (ITEM): ID  TID  Previous Status 1   2       A 2   2       B 3   2       C 4   3       A ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Anonymous,

 

"I have a relation beetween tables in another column."

I tested such a scenario where there existing a relationship based on another column, but the results returned by LOOKUPVALUE looked as expected.

 

Please show us how did you establish this relationship. Please provide some more detailed repro steps.

 

Regards,

Yuliana Gu