Indicate a partial match from a column of data

Hi Folks

I am trying to do the following task in Excel (2010)

I have a column of text in column A1...

MELTON MOWBRAY B S
EDF ENERGY
ROYAL SUNALLIANCE
PLUSNET PLC
YORKSHIRE WATER
BRITISH RED CROSS
BARNSLEY MBC INCME
WWW.GIFFGAFF.COM ONLINE STORE
TV LICENCE MB


In cell B1 I have the text "EDF ENERGY JANUARY"

I want cell C1 to indicate (change from 0 to 1) that there is a partial match "EDF ENERGY" from the list in column A

What is the best way of achieving this?

Many thanks
Paul.

in C1:
=IF(OR(NOT(ISERROR(FIND(B1,A1:A12))),NOT(ISERROR(FIND(A1:A12,B1)))),1,0)
it's an array formula so confirm with ctrl+shift+enter