Forum Discussion

New Member

1 year ago

Solved

Unable to create new calculated column using a lookup value column

Hello All, I'm not sure if this is a glitch or if I'm doing something wrong. I've done this plenty of times in the past but it is not working now. I have two calculated columns using the LOOKUPVAL...

danextian
1 year ago
Hi VonMurray

If there's a direct relationship between the two tables, use RELATED function on the many side of the relationship to access the value from the one side.

New Member

1 year ago

Thank you all very much. One of my data tables had duplicates and blanks; I cleaned that up. That allowed the RELATED function to work.