Forum Discussion

VonMurray's avatar
VonMurray
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...
Need Help
  • danextian's avatar
    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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

If there are relationships then use RELATED. If there are no relationships, use TREATAS.  LOOKUPVALUE should only be used if really, really nothing else works.