Dec 16 2018 07:57 PM
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
Dec 16 2018 08:26 PM
SolutionHi
plain VLOOKUP():
=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
Dec 16 2018 08:35 PM
Thank you so much!
Dec 16 2018 08:26 PM
Solution