Forum Discussion
ozgothic
Dec 16, 2018Copper Contributor
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
Hi
plain VLOOKUP():
=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
2 Replies
- Detlef_LewinSilver Contributor
Hi
plain VLOOKUP():
=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
- ozgothicCopper Contributor
Thank you so much!