SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-302569%22%20slang%3D%22en-US%22%3ETrying%20to%20find%20duplicate%20values%20across%20two%20sheets%20and%20put%20unique%20value%20in%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302569%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20sheets%2C%20each%20with%20a%20list%20of%20email%20addresses%20in%20column%20A.%20In%20Sheet%201%20I%20also%20have%20a%20B%20column%20showing%20the%20date%20the%20email%20was%20created.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20that%20runs%20in%20Sheet%202%20column%20B%2C%20that%20identifies%20if%20there%20are%20any%20duplicates%20in%20Sheet%201%20column%20A%20list%20and%20if%20there%20is%20it%26nbsp%3Bdisplays%20the%20value%20from%20Sheet%201%20Column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20uploaded%20a%20mock%20worksheet%20which%20shows%20the%20result%20I%20want%20to%20achieve%20in%20Sheet%202%2C%20B18.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20this%20is%20doable%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-302569%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302573%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20find%20duplicate%20values%20across%20two%20sheets%20and%20put%20unique%20value%20in%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302573%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-302572%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20find%20duplicate%20values%20across%20two%20sheets%20and%20put%20unique%20value%20in%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-302572%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplain%20VLOOKUP()%3A%3C%2FP%3E%3CPRE%3E%3DIFNA(VLOOKUP(A2%2CSheet1!%24A%242%3A%24B%2421%2C2%2CFALSE)%2C%22%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
ozgothic
New Contributor

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 Replies
Solution

Hi

 

plain VLOOKUP():

=IFNA(VLOOKUP(A2,Sheet1!$A$2:$B$21,2,FALSE),"")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies