Forum Discussion

ozgothic's avatar
ozgothic
Copper Contributor
Dec 16, 2018
Solved

Trying to find duplicate values across two sheets and put unique value in results

Hi,

 

I have two sheets, each with a list of email addresses in column A. In Sheet 1 I also have a B column showing the date the email was created.

 

I am trying to create a formula that runs in Sheet 2 column B, that identifies if there are any duplicates in Sheet 1 column A list and if there is it displays the value from Sheet 1 Column B.

 

I have uploaded a mock worksheet which shows the result I want to achieve in Sheet 2, B18.

 

Wondering if this is doable?

 

Any help would be greatly appreciated

 

Kind regards,

 

Peter

2 Replies