Need Help creating a formula to search for duplicates in one column vs the other

[kluna90]

Hi,

I need help creating a formula to compare two different data sets with similar information and to see what values are duplicates... For example If you look below at the screen shot I want to see what funds in column A also show up in the fund2 column (column E).. So I can do a vlookup to figure this out but there has to be a better way no? Like I was thinking I could do and IF statement =IF(A2=E:E. "Duplicate","Unique") this gives me an error though so I assume IF wouldn't work here? Is there a better way of doing this? Thanks for the help!

 

[kluna90]

=IFERROR(VLOOKUP(A2,$E$2:$E$748,1,FALSE),"Unique") actually this is the formula I did and it seems to work lol

 

[Fluff]

You could also use

=IF(COUNTIFS(E:E,A2)=0,"Unique","Duplicate")