Excel formula will true if have same word in other column

[shacol03]

Hi all,

Please help me to fix this

I have a problem. I want to put a formula in Column B which is "True" If Column A have same word in Column E within the column.

Sample

Column A	Column B
Fc Hoechst	True
Al Hidd	False
Dinamo Minsk	True
The Balloon Place	True
100 Ball Court	True
Fc Innsbruck Union	True
ABC Jack Street	True

<tbody>
</tbody>

Column E

Minsk Shoot

Food Court

Hoechst Way

Qalili

Fc Stated Innsbruck

The Balloon Place

Street Food

<tbody>
</tbody>

<tbody></tbody>

Pls. help me I'll do a report for this.

Thanks & Regards,
Roy

 

[oldbrewer]

Column A

Column B

Column E

col L

Fc Hoechst

TRUE

Minsk Shoot

Minsk

Shoot

Al Hidd

FALSE

Food Court

Food

Court

Dinamo Minsk

TRUE

Hoechst Way

Hoechst

Way

The Balloon Place

TRUE

Qalili

100 Ball Court

TRUE

Fc Stated Innsbruck

Fc

Stated Innsbruck

Stated

Innsbruck

Fc Innsbruck Union

TRUE

The Balloon Place

The

Balloon Place

Balloon

Place

ABC Jack Street

TRUE

Street Food

Street

Food

Column A

Fc Hoechst

Fc

Hoechst

the above answers

Al Hidd

Al

Hidd

are pulled from

Dinamo Minsk

Dinamo

Minsk

col L output

The Balloon Place

The

Balloon Place

Balloon

Place

100 Ball Court

100

Ball Court

Ball

Court

Fc Innsbruck Union

Fc

Innsbruck Union

Innsbruck

Union

ABC Jack Street

ABC

Jack Street

Jack

Street

Fc Hoechst

1

1

0

0

0

0

TRUE

Al Hidd

0

0

0

0

0

0

FALSE

Dinamo Minsk

0

1

0

0

0

0

TRUE

The Balloon Place

1

1

1

1

0

0

TRUE

100 Ball Court

0

0

0

1

0

0

TRUE

Fc Innsbruck Union

1

0

1

0

0

0

TRUE

ABC Jack Street

0

0

0

1

0

0

TRUE

I broke column E phrases down to individual words

and same for column A phrases

I then searched F2:K8 for EACH word in the column A table

if total matches = 1 or more, TRUE, otherwise false

I put in 2 extra columns to allow for phrases with 4 words - easy to extend

<colgroup><col><col><col span="2"><col><col><col><col span="7"></colgroup><tbody>
</tbody>