Find if value is in another table

[Anton-G]

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

[Anonymous · Accepted solution]

@Anton-G 

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

[amitchandak]

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.