Hello,

Attachment 131783
I am new to formulas in excel, and I am trying to understand how to return values from a third column, comparing two other columns in an excel sheet. This is a sample of my data:

Col A Col B Col C Col D
Row 1 Blue| blue(at)mail.com| Blue| purple(at)mail.com
Row 2 Green| green(at)mail.com| Orange| red(at)mail.com
Row 3 Orange| orange(at)mail.com| Yellow| yellow(at)mail.com
Row 4 Purple| purple(at)mail.com|
Row 5 Red| red(at)mail.com|
Row 6 Yellow| yellow(at)mail.com|


In Column D I would like to have returned the e-mail adresses from column B, but only for those values which are uniqe comparing column A and column C (i.e. if I did this manually I would not enter any e-mail adresses for Blue, Orange and Yellow in Colum D, because these values are shared by Column A and C. Purple, red and yellow, however, are unique to Column A, and so I would like to have the e-mail addresses associated with these values returned to Column D.)

It does not really matter where in Column D the e-mail adresses are returned, although it would be nice to have them listed from Row 1 and downwards, as shown in the example I present above.

If the example above is difficult to read, please take a look at the picture attached to this post (The picture offers the same example.)

Any help on this matter is greatly appreciated!
Thank's in advance.