Check the text secreted by vertical bar with column C

[Kishan]

Using Excel 2000</SPAN></SPAN>

Hi,</SPAN></SPAN>

I want to check E5, F5 or G5 text secreted by vertical bar with column C data if find then place result as "OK" in the cells E6:G23</SPAN></SPAN>

Example...</SPAN></SPAN>

Book1
	A	B	C	D	E	F	G	H	I
1
2
3
4
5			P1		1 | X	1 | 2	X | 2
6			X		OK		OK
7			X		OK		OK
8			X		OK		OK
9			2			OK	OK
10			1		OK	OK
11			X		OK		OK
12			X		OK		OK
13			1		OK	OK
14			1		OK	OK
15			1		OK	OK
16			X		OK		OK
17			1		OK	OK
18			1		OK	OK
19			X		OK		OK
20			1		OK	OK
21			1		OK	OK
22			2			OK	OK
23			1		OK	OK
24
25
SHEET11

Thank you in advance</SPAN></SPAN>

Regards,</SPAN>
Kishan</SPAN></SPAN>

 

[gaz_chops]

Maybe

=IF(ISNUMBER(FIND($C7,E$6)),"OK","")

 

[Rick Rothstein]

Put this formula in cell E6 and copy it across to cell G6, then select the range E6:G6 and copy it down to the bottom of your data...

=IF(ISNUMBER(FIND($C6,E$5)),"OK","")

 

[mumps]

Place this formula in E6 and copy across and down: =IF(ISNUMBER(SEARCH($C6,E$5)),"OK","")

 

[Kishan]

Maybe

=IF(ISNUMBER(FIND($C7,E$6)),"OK","")

Thank you gaz_chops, got result as required only correcting the ranges</SPAN></SPAN>

Happy 2019! I wish you a beautiful, magical new year!</SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Kishan </SPAN></SPAN>

 

[Kishan]

Put this formula in cell E6 and copy it across to cell G6, then select the range E6:G6 and copy it down to the bottom of your data...

=IF(ISNUMBER(FIND($C6,E$5)),"OK","")

Thank you Rick, got result as required perfect! </SPAN></SPAN>

Happy 2019! I wish you a beautiful, magical new year!</SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[Kishan]

Place this formula in E6 and copy across and down: =IF(ISNUMBER(SEARCH($C6,E$5)),"OK","")

Thank you mumps, got result as required perfect! </SPAN></SPAN>

Happy 2019! I wish you a beautiful, magical new year!</SPAN></SPAN>

Kind Regards</SPAN></SPAN>
Kishan</SPAN></SPAN>

 

[mumps]

Glad we could help.