Need a Formula to

[ssj]

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>

 

[jarjarbingie]

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")

 

[kevatarvind]

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

 

[Akashwani]

Hi,

Does this work for you?...

Excel Workbook
	A	B	C	D
1	Column1	Column2	Result
2	1	2	Yes
3	2	1	Yes
4	3	4	No
5		2	Yes
6		1	Yes
7		3	Yes
8		5	No
9		3	Yes
10
Sheet4

The formula in C2 needs to be copied down.

I hope that helps.

Ak

 

[prince141987]

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

Regards
Prince

 

[vds1]

Another Way,


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