LOOKUPVALUE Ignore & Include

[Tob_P]

Hi,

I have two tables..

Table 1

No	Delivery
BAR1	1
CAR2	1
DIM3	1
GUM4	0

Table 2

No

BAR1

CAR2

DIM3

GUM4

Where in Table 1, Delivery outputs 1, then this is TRUE and O is FALSE, so I want a calculated column whereby if Delivery = 1, and they lookup to Table 2, then I would like to output 'Ignore' and if Delivery = 0, then I would like to output 'Include'.

Can anyone help? There will be values included in both tables that won't necessarily match.

Thanks

[v-yangliu-msft · Accepted solution]

Hi  @Tob_P ,

Here are the steps you can follow：

1. Create calculated column.

Column =
IF(
    'Table1'[Delivery]=1,TRUE(),FALSE())

2. Result:

Is this the result you expected.

Best Regards,

Liu Yang

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

[Tob_P]

If it helps, I think I can simplify this by adding a conditional column in Table 1 so that if delivery = 1, then output TRUE