Forum Discussion

MarcUrdang's avatar
MarcUrdang
Icon for Post Patron rankPost Patron
6 years ago

Comparing a field from one table with a field from another table. ie IF(X=Y,"true","false")

Please can you advise how to compare a filed in one table to a field in another table. ie If(x=y,"true","false"

Need Help

18 Replies

  • kentyler's avatar
    kentyler
    Icon for Solution Sage rankSolution Sage
    6 years ago

    The simplest way is to create a realtionship between the tables. Have you tried that ? Then you can write your forumla in a calculated column.

    • MarcUrdang's avatar
      MarcUrdang
      Icon for Post Patron rankPost Patron
      6 years ago

      Hi .. thank you for your response.... sure I have .. I use fieds from there in a number of calcs. 

       

      I could attach the workbook for you to see? 

       

      thanks

      Marc