How to find the Match with the ranges

[xlhelp15]

Hello All - Please help me for the below request.

I need to match values from RowA with remaining Columns(RowB to RowE) and it needs to return "Yes" if values match within that range and return "NO" when there is no match in that.

for eg,
if I take value, 553987601100 that is found in cells(8,8) and it needs to return YES, if not return NO.

Your timely help is greatly appreciated !

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]RowA[/TD]
[TD="align: center"]RowB[/TD]
[TD="align: center"]RowC[/TD]
[TD="align: center"]RowD[/TD]
[TD="align: center"]RowE[/TD]
[/TR]
[TR]
[TD]553987601100
[/TD]
[TD]281840401112
[/TD]
[TD]711073801173
[/TD]
[TD]846035901140
[/TD]
[TD]714205401379
[/TD]
[/TR]
[TR]
[TD]715845501625
[/TD]
[TD]639427901076
[/TD]
[TD]507852901117
[/TD]
[TD]507852901117
[/TD]
[TD]846035901140
[/TD]
[/TR]
[TR]
[TD]902702801017
[/TD]
[TD]270493601138
[/TD]
[TD]507852901117
[/TD]
[TD]714205401379
[/TD]
[TD]864770201178
[/TD]
[/TR]
[TR]
[TD]864770201201
[/TD]
[TD]687484701023
[/TD]
[TD]902702801017
[/TD]
[TD]711073801173
[/TD]
[TD]714205401379
[/TD]
[/TR]
[TR]
[TD]921575001002
[/TD]
[TD]507852901117
[/TD]
[TD]711073801173
[/TD]
[TD]507852901117
[/TD]
[TD]507852901117
[/TD]
[/TR]
[TR]
[TD]864770201171
[/TD]
[TD]864770201201
[/TD]
[TD]714205401379
[/TD]
[TD]708994701229
[/TD]
[TD]846035901140
[/TD]
[/TR]
[TR]
[TD]508993001157
[/TD]
[TD]846035901140
[/TD]
[TD]507852901117
[/TD]
[TD]715845501625
[/TD]
[TD]507852901117
[/TD]
[/TR]
[TR]
[TD]864770201178
[/TD]
[TD]507852901117
[/TD]
[TD]708994701229
[/TD]
[TD]851739501077
[/TD]
[TD]553987601100
[/TD]
[/TR]
</tbody>[/TABLE]

 

[primuspaul]

Hello All - Please help me for the below request.

I need to match values from RowA with remaining Columns(RowB to RowE) and it needs to return "Yes" if values match within that range and return "NO" when there is no match in that.

for eg,
if I take value, 553987601100 that is found in cells(8,8) and it needs to return YES, if not return NO.

Your timely help is greatly appreciated !

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]RowA[/TD]
[TD="align: center"]RowB[/TD]
[TD="align: center"]RowC[/TD]
[TD="align: center"]RowD[/TD]
[TD="align: center"]RowE[/TD]
[/TR]
[TR]
[TD]553987601100
[/TD]
[TD]281840401112
[/TD]
[TD]711073801173
[/TD]
[TD]846035901140
[/TD]
[TD]714205401379
[/TD]
[/TR]
[TR]
[TD]715845501625
[/TD]
[TD]639427901076
[/TD]
[TD]507852901117
[/TD]
[TD]507852901117
[/TD]
[TD]846035901140
[/TD]
[/TR]
[TR]
[TD]902702801017
[/TD]
[TD]270493601138
[/TD]
[TD]507852901117
[/TD]
[TD]714205401379
[/TD]
[TD]864770201178[/TD]
[/TR]
[TR]
[TD]864770201201
[/TD]
[TD]687484701023
[/TD]
[TD]902702801017[/TD]
[TD]711073801173
[/TD]
[TD]714205401379
[/TD]
[/TR]
[TR]
[TD]921575001002
[/TD]
[TD]507852901117
[/TD]
[TD]711073801173
[/TD]
[TD]507852901117
[/TD]
[TD]507852901117
[/TD]
[/TR]
[TR]
[TD]864770201171
[/TD]
[TD]864770201201[/TD]
[TD]714205401379
[/TD]
[TD]708994701229
[/TD]
[TD]846035901140
[/TD]
[/TR]
[TR]
[TD]508993001157
[/TD]
[TD]846035901140
[/TD]
[TD]507852901117
[/TD]
[TD]715845501625[/TD]
[TD]507852901117
[/TD]
[/TR]
[TR]
[TD]864770201178
[/TD]
[TD]507852901117
[/TD]
[TD]708994701229
[/TD]
[TD]851739501077
[/TD]
[TD]553987601100[/TD]
[/TR]
</tbody>[/TABLE]

You need to create a table. Then in B column:

=IF(COUNTIF(Table1[[RowB]:[RowE]],[@RowA])>0,"YES","NO")

It basically counts how many instances of the rowA entry is in the other rows and returns a number. If it's more than 0, you get YES.