match for email address from different tables

[renjithpl]

Hi All,

I have two different table loaded in my application, both tables have no connection

Below is my first table

Matter ID	Name of the Matter	Email ID of Notice Recipient
447237	DERIPASKA, OLEG VLADIMIROVICH	William.Bozza@hotmail.com
447237	DERIPASKA, OLEG VLADIMIROVICH	alexandra.kogan@hotmail.com

below is my second table

manager_name	Email Address	Job_Title
James E Staley	abbbb@gmail.com	Executive
Barry L Zubrow	abcd@gmail.com	Risk Methodology Executive
James E Staley	William.Bozza@hotmail.com	Advisory Executive
Frank J Bisignano	michael.j.ahearn@jpmchase.com	HR Bus Partner - Executive

I want to write a code, like =if ([Email ID of Notice Recipient] = [Email Address], 'Yes', 'No')

Basically my second table has a directory of email ids, so if atleast one email address matches from table one with the table two [Email Address], then it should say yes else no.

Regards

Renjith

[its_anandrjs]

Hi,

It is because null values so for that you need to put some coding for that column like

=isnull ( EMAIL ), 'No' , 'Yes'

Regards

Anand

[Miguel_Angel_Baeyens]

Renjith,

Check the application attached. I don't see any "null" value even when there is no corresponding address (in that case the result is "No"). Am I missing something?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[its_anandrjs · Accepted solution]

Hi,

See the sample file for the clearity of the is it a solution for you.

Regards

Anand