welcome to the forum, edsters. is this what you need?
=IFERROR(LOOKUP(2^15,SEARCH(Sheet2!$A$1:$A$15,A1),Sheet2!$B$1:$B$14),"")