Matching column a string with a single value

[Sk8ect]

Model	Manufactur and Model
H834	Cuisinart H297
H296	Hitatchi L945
L8435	Hitchachi H834
N923k1	Cuisinart H296

<tbody>
</tbody>

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