Return True/False by searching a value in an array of string

Hi all, appreciate if anyone can help. Thank you.

A;B;C			A	Yes
D;E			B	Yes
			C	Yes
J			D	Yes
K;L;M			E	Yes
N;O;P;Q			F	No
			G	No
			H	No
			I	No
			J	Yes
			K	Yes
			L	Yes
			M	Yes
			N	Yes
			O	Yes
			P	Yes
			Q	Yes
			R	No
			S	No
			T	No
			U	No
			V	No

A1:A6 - Array - Data Source
F1:F22 - Key words (can be one character or a string, but I use one character as an example)
G1:G22 - expected result (will display "Yes" if the key word is exist in any cells of the Array, otherwise, "No")

Try this in G1:

=IF(COUNTIF(A$1:A$6,"*"&F1&"*")>0,"Yes","No")

then copy down to G22.

Hope this helps.

Pete

wow ... Thanks all of you .. All are working fine on the example & my real situation. Thank you Thank you.

Glad to hear it.

Go for the shorter one - less characters to type !!

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete

Sorry .. I have one more question .. How about this? As VLOOKUP can return only right column's value. Thank you.

1	A;B;C			A	1
2	D;E			B	1
				C	1
3	J			D	2
4	K;L;M			E	2
5	N;O;P;Q			F
				G
				H
				I
				J	3
				K	4
				L	4
				M	4
				N	5
				O	5
				P	5
				Q	5
				R
				S
				T
				U
				V

I made it ... =INDEX($A$1:$A$6,MATCH("*"&E1&"*",$B$1:$B$6,0),1) .. Thank you ...

Thanks XOR LX, I made one which similar with yours. Anyway, Thanks a lot for your help.