Matching a List With Duplicates Values

[Excel_77]

Hi,

I have a list of reference numbers in column A, some of these reference numbers have duplicated. What I want to do is check the list and for every reference number that matches to what is in column A of "Tab2", I want Yes returned. I tried to use Vlookup but this seems to ignore duplicates.

Any suggestions?

Example below of what I want returned in column B of tab 1.

Tab1

Column A

11111
12345
11111
13421
43343
23232


Column B

Yes
No
Yes
No
No
Yes

Tab2

Column A

11111
33333
88888
23232

 

[Aladin Akyurek]

In B2 of Tab1 enter and copy down:

=IF(ISNUMBER(MATCH(A2,Tab2!A:A,0)),"Yes","No")