Matching column a string with a single value

[Sk8ect]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Model[/TD]
[TD]Manufactur and Model[/TD]
[/TR]
[TR]
[TD]H834[/TD]
[TD]Cuisinart H297[/TD]
[/TR]
[TR]
[TD]H296[/TD]
[TD]Hitatchi L945[/TD]
[/TR]
[TR]
[TD]L8435[/TD]
[TD]Hitchachi H834[/TD]
[/TR]
[TR]
[TD]N923k1[/TD]
[TD]Cuisinart H296[/TD]
[/TR]
</tbody>[/TABLE]
I have 2 columns on seperate sheets one will contain a single text value, the other a string. I want to return true in the Manufacturer and Model sheet if it is found on the Model sheet.

 

[AlKey]

Assuming Manufactur and Model is located on Sheet2 A2:A5

Enter formula on Sheet1 in cell B2 and copy down

[B]=ISNUMBER(MATCH("*"&A2,Sheet2!A$2:A$5,0))[/B]

Excel 2016 (Windows) 32 bit
	A	B
1	Model
2	H834	TRUE
3	H296	TRUE
4	L8435	FALSE
5	N923k1	FALSE
Sheet1