Starts with anything in a list

[mikebishop]

Have a list A and am looking to find if anything in this list starts with anything in list B

[TABLE="width: 271"]
<tbody>[TR]
[TD]My things A[/TD]
[TD][/TD]
[TD][/TD]
[TD]My list B[/TD]
[/TR]
[TR]
[TD]red coasts[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD]red[/TD]
[/TR]
[TR]
[TD]red hats[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]redhats[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]blue hats[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]bluehats[/TD]
[TD="align: center"]FALSE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]green hats[/TD]
[TD="align: center"]TRUE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Help please!

 

[wideboydixon]

Book1
	A	B	C
1	Things	Match?	List
2	red coats	TRUE	red
3	red hats	TRUE	green
4	redhats	TRUE
5	blue hats	FALSE
6	bluehats	FALSE
7	green hats	TRUE
Sheet1

Cell Formulas
Range	Formula
B2	{=SUM(COUNTIF($A2,$C$2:$C$3&"*"))>0}
Press CTRL+SHIFT+ENTER to enter array formulas.

Extend $C$2:$C$3 as necessary.

WBD