# Need a Formula to

#### ssj

##### New Member
Hello Team,

I have a data as per below, in column1 (uniques) and column 2 (Multiples) and in column Result i need as per the below results.

Kindly help on this

 Column1 Column2 result 1 2 yes 2 1 yes 3 4 No 2 yes 1 yes 3 yes 5 No 3 yes

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
say the first list is in A2:A4 and second list in B2:B9,

C2 = IF(ISERROR(VLOOKUP(B2,\$A\$2:\$A\$4,1,0)),"No", "Yes")

=IF(ISERROR(MATCH(B2,A:A,0)),"NO","Yes")

Hi,

Does this work for you?...

Excel Workbook
ABCD
1Column1Column2Result
212Yes
321Yes
434No
52Yes
61Yes
73Yes
85No
93Yes
10
Sheet4

The formula in C2 needs to be copied down.

I hope that helps.

Ak

=IF(ISERROR( MATCH(D1,\$C\$1:\$C\$3,0)),"No","Yes")

Regards
Prince

Another Way,

=IF(SUMPRODUCT(((\$A\$2:\$A\$4)=B2)+0)=1,"Yes","No")

Replies
1
Views
361
Replies
5
Views
468
Replies
1
Views
119
Replies
2
Views
189
Replies
21
Views
789

1,203,052
Messages
6,053,233
Members
444,648
Latest member
sinkuan85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back