Comparision of two tables

[praneshsapmm]

Hello ,

I have this requirement to write a formula : 

4 columns A , B , C  and D are a part of workflow . 

A = Sales Area

B = Jurisdiction 

C = email id of Sales Person 

D = copy of column c 

A	B	C	D
SalesArea1	SalesArea1	aac@gmail.com	aac@gmail.com
SalesArea2	SalesArea5	bbx@gmail.com	bbx@gmail.com
SalesArea3	SalesArea3	ccx@gmail.com	ccx@gmail.com
SalesArea5	SalesArea5	xsx@gmail.com	xsx@gmail.com

My requirement is if A !=B then column D must be updated with the corresponding email id available for B .

A	B	C	D
SalesArea1	SalesArea1	aac@gmail.com	aac@gmail.com
SalesArea2	SalesArea5	bbx@gmail.com	xsx@gmail.com
SalesArea3	SalesArea3	ccx@gmail.com	ccx@gmail.com
SalesArea5	SalesArea5	xsx@gmail.com	xsx@gmail.com

Thanks

[Qiu]

@praneshsapmm 
Sorry. attached the files again.

Hope I get you right.

[PKoya]

Hi,

Looks fairly straightforward.

Hope this is the output you are trying to achieve. This should help in that case.

Thanks,

PK

[praneshsapmm]

@Qiu @PKoya  ,

Ideally it should be something like this but not working for me .

D = if [A]!= [B] then [B(D)] else [D] endif .

Thanks

[Qiu]

@praneshsapmm 
 I believe that is what I and @PKoya ar trying to do.

or you can provide a larger dataset to validate?