Forum Discussion

kartiklal70's avatar
kartiklal70
Frequent Visitor
3 years ago

Lookupvalue when Value doesn't exist in One Table

Hi All,    I have two tables - A CSR and a Milestones Table. They are joined on the CSR field. Some CSRs don't exist in the Milestones table (See column 3 in the screenshot - CSR-0329 does not exi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi kartiklal70 ,

 

In your case, you can create a calculated column like

Lookup Column =
IF (
    CSR[CSR] = "CSR-0329"
        && 'Milestones'[Primary CSR] = "CSR-0007",
    'Milestones'[AHOP Issued Date],
    LOOKUPVALUE (
        'Milestones'[AHOP Issued Date],
        CSR[CSR], 'Milestones'[Primary CSR]
    )
)

 

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kartiklal70's avatar
kartiklal70
Frequent Visitor
3 years ago

Anonymous ,

 

I don't want to hardcode it as there are other such cases in my dataset. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi kartiklal70 ,

     

    You'd better provide some sample data of your two tables, along with the expected results.

    I need more details.

    Is there a relationship between the two tables?

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.