Cell Comparison and Display Value Yes Or NO

[manoj18071965]

I have multiple values in Rows and Columns in MS Excel 2010 as follow. I want to populate value Yes or No if any or multiple value appearing in Columns Headers are appearing in Row values Example shown below:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Value[/TD]
[TD]709226000[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70"]726002000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70"]370235000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 70"]
<tbody>[TR]
[TD="class: xl65, width: 70"]726005000[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]PCLO=709226000
PCLX=709223000
PCLX=709224000
PCLX=709225000


[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]PCLO=370389000
PCLX=370230000
PCLX=370235000



[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]PCLX=713186000
PCLX=726002000
PCLX=726003000
PCLX=726004000
PCLX=726005000




[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

 

[shknbk2]

Book1
	A	B	C	D	E
1	Value	709226000	726002000	370235000	726005000
2
3	PCLO=709226000 PCLX=709223000 PCLX=709224000 PCLX=709225000	Yes	No	No	No
4	PCLO=370389000 PCLX=370230000 PCLX=370235000	No	No	Yes	No
5	PCLX=713186000 PCLX=726002000 PCLX=726003000 PCLX=726005000 PCLX=726004000	No	Yes	No	Yes
Sheet1

Cell Formulas
Range	Formula
B3	=IFERROR(IF(SEARCH(B$1,$A3)> 1,"Yes","No"),"No")

Copy the formula in B3 across to E3 then copy all down to B5:E5.