Hi Sixthsense.. I think i've actually stumbed across something that gives me my answer:

=IFERROR(LOOKUP(2^15,SEARCH(Search_Strings,G2),Search_Strings),"")

Where Search_Strings is the named range and contains the strings to be searched
G2 is the cell to be searched

Thanks for your help!