Forum Discussion

ozgothic's avatar
ozgothic
Copper Contributor
Dec 16, 2018
Solved

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 ...
  • Detlef_Lewin's avatar
    Dec 16, 2018

    Hi

     

    plain VLOOKUP():

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