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:

Value	709226000	726002000 <tbody> </tbody>	370235000 <tbody> </tbody>	726005000 <tbody> </tbody>
PCLO=709226000 PCLX=709223000 PCLX=709224000 PCLX=709225000	Yes	No	No	No
PCLO=370389000 PCLX=370230000 PCLX=370235000	No	No	Yes	No
PCLX=713186000 PCLX=726002000 PCLX=726003000 PCLX=726004000 PCLX=726005000	No	Yes	No	Yes

<tbody>
</tbody>

 

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