Compare columns from unrelated tables

[kshre]

Hello,

In a custom column I need to compare two email columns from unrelated tables, if an email exists in both tables the column will return dont include.

Table A                                             Table B

Email                    Email Include       Email                        
aaa@email.com   Don't Include       aaa@email.com

bbb@email.com   Include                

ccc@email.com    Don't Include       ccc@email.com

Help will be much appreciated! 

[jdbuchanan71 · Accepted solution]

@kshre , give this a try.

Email Include =
IF (
    ISBLANK ( LOOKUPVALUE ( 'Table B'[Email], 'Table B'[Email], 'Table A'[Email] ) ),
    "Include",
    "Don't Include"
)

I'm assuming you want to add this to Table A

[kshre]

@jdbuchanan71 , Works, thank you!