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 ...
- Dec 16, 2018
Hi
plain VLOOKUP():
=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
Detlef_Lewin
Dec 16, 2018Silver Contributor
Hi
plain VLOOKUP():
=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
- ozgothicDec 16, 2018Copper Contributor
Thank you so much!