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

[ozgothic]

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 · Accepted solution]

Hi

plain VLOOKUP():

=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")

[#3]

Thank you so much!