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 !

RowA	RowB	RowC	RowD	RowE
553987601100	281840401112	711073801173	846035901140	714205401379
715845501625	639427901076	507852901117	507852901117	846035901140
902702801017	270493601138	507852901117	714205401379	864770201178
864770201201	687484701023	902702801017	711073801173	714205401379
921575001002	507852901117	711073801173	507852901117	507852901117
864770201171	864770201201	714205401379	708994701229	846035901140
508993001157	846035901140	507852901117	715845501625	507852901117
864770201178	507852901117	708994701229	851739501077	553987601100

<tbody>
</tbody>

 

[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 !

RowA	RowB	RowC	RowD	RowE
553987601100	281840401112	711073801173	846035901140	714205401379
715845501625	639427901076	507852901117	507852901117	846035901140
902702801017	270493601138	507852901117	714205401379	864770201178
864770201201	687484701023	902702801017	711073801173	714205401379
921575001002	507852901117	711073801173	507852901117	507852901117
864770201171	864770201201	714205401379	708994701229	846035901140
508993001157	846035901140	507852901117	715845501625	507852901117
864770201178	507852901117	708994701229	851739501077	553987601100

<tbody>
</tbody>

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.