Forum Discussion
Solved
Find if value is in another table
Hello
Need to find if a value is in another table.
Has a table that contains inventory numbers (List).
Has two tables containing inventory (List_1 and List_2).
Want to add two columns that contain a "Yes" or "No" depending on if the value found in the other tables.
The tables containing inventory can have the same inventory number more than once.
Inventory numbersInventory 1Inventory 2
Use in values(), this is very simple to check if a value in others columns or tables.
Is in 1 = IF(List[ID] in VALUES(List_1[ID]),"Yes","NO") Is in 2 = IF(List[ID] in VALUES(List_2[ID]),"Yes","No")Best regards
Paul Zheng
2 Replies
Try
Is in 1 = if(isblank(countx(filter(list1,list1[ID]=list[ID]),list1[ID])),"No","Yes") Is in 2 = if(isblank(countx(filter(list2,list2[ID]=list[ID]),list2[ID])),"No","Yes")Appreciate your Kudos.
Use in values(), this is very simple to check if a value in others columns or tables.
Is in 1 = IF(List[ID] in VALUES(List_1[ID]),"Yes","NO") Is in 2 = IF(List[ID] in VALUES(List_2[ID]),"Yes","No")Best regards
Paul Zheng
