Fuzzy search of values from one column in another

[chilly_bang]

I have one column with words, and another one with sentences. I want get into knowledge, which sentences from the second column contain words from the first column, putting into the third column something like "contains / not contains". Case insensitive could it be.

Example:

+-------------+----------------------------------------------------+---------------+
| Salta       | Kabul,Kabul,Afghanistan                            | don't contain |
+-------------+----------------------------------------------------+---------------+
| united      | Luanda,Luanda Province,Angola                      | don't contain |
+-------------+----------------------------------------------------+---------------+
| test        | The Valley,Anguilla                                | don't contain |
+-------------+----------------------------------------------------+---------------+
| Argentina   | Abu Dhabi,Abu Dhabi,United Arab Emirates           | contains      |
+-------------+----------------------------------------------------+---------------+
| anotherTest | Ajman,Ajman,United Arab Emirates                   | don't contain |
+-------------+----------------------------------------------------+---------------+
| End         | Al Ain,Abu Dhabi,United Arab Emirates              | don't contain |
+-------------+----------------------------------------------------+---------------+
| Of          | Dubai,Dubai,United Arab Emirates                   | don't contain |
+-------------+----------------------------------------------------+---------------+
| Test        | Ras Al-Khaimah,Ras al Khaimah,United Arab Emirates | don't contain |
+-------------+----------------------------------------------------+---------------+
| Yes         | Salta,Salta Province,Argentina                     | contains      |
+-------------+----------------------------------------------------+---------------+

Tried it with

=IF(ISERROR(VLOOKUP(A1,$B$1:$B$9, 1, FALSE)),"Not Exist","Exist" )

, but no luck...

 

[ParamRay]

Enter as array formula (Ctrl+Shift+Enter):

= IF(SUM(1 * ISNUMBER(SEARCH(A1,$B$1:$B$9))), "Exists", "Not Exists")

 

[Fluff]

How about

Book1
	A	B	C	D
1			Any word	Full match
2	Salta	Kabul,Kabul,Afghanistan	Doesn't contain	Doesn't contain
3	united	Luanda,Luanda Province,Angola	Doesn't contain	Doesn't contain
4	test	The Valley,Anguilla, Salta	Contains	Contains
5	Argentina	Abu Dhabi,Abu Dhabi,United Arab Emirates	Contains	Doesn't contain
6	Al ain	Ajman,Ajman,United Arab Emirates	Contains	Doesn't contain
7	End	Al Ain,Abu Dhabi,United Arab Emirates	Contains	Contains
8	Of	Dubai,Dubai,United Arab Emirates	Contains	Doesn't contain
9	Test	Ras Al-Khaimah,Ras al Khaimah,United Arab Emirates	Contains	Doesn't contain
10	Yes	Salta,Salta Province,Argentina	Contains	Contains
Lookup

Cell Formulas
Range	Formula
C2	=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($A$2:$A$10,B2)))),"Contains", "Doesn't contain")
D2	=IF(SUMPRODUCT(--(ISNUMBER(SEARCH($A$2:$A$10&",",B2&",")))),"Contains", "Doesn't contain")