Forum Discussion
Solved
No Relation Between Table
Hey Guys, Simple Question for you, I have two tables one for Badge IDs and Another for Persons Name. I need to know how to make it when there is no relation that it will show up as "Invalid Badge...
Hi Boveitj,
Assume there is a relationship between Table 1 and Table 2 based on IDs, then you can create a Calculated column like below:
Column1= IF(IsBlank(Related(Table 2[Names])),"Invalid Badge ID",Related(Table 2[Names]))
Best Regards,
Qiuyun Yu
Could you not create an if function? If values match those in table a, return name, else return 0/invalid (in the case there is no match) ?