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 LOOKUPVALUE function to bring data back from other tables. Both have direct relationships.

I want to create a calculated column to add the two values together.

As soon as I hit enter, the formula dissapears.  No error messages appear.

 

It does this with any formula I tie to a calculated column using the LOOKUPVALUE function.

Do you know if this is a glitch or am I doing something wrong?

 

 

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.

4 Replies

  • 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.

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    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.

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