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
View best response
Thank you so much!