Vlookup using a partial text match

[JGROVE]

I am trying to use Vlookup to find a specific set of caracters to return the
match to that set. The problem is I am trying to pull the set from a
description.

Example:
Lookup value:
ZZWTH XXX SSKLDF

Array has values in cells as follows
Col 1 COL 2
WTH Wheat Home Feilds Farms

I need Vlookup to scan the lookup value for the WTH (that is never int he
same place in the lookup value) and match that to col1 and return col2 not
sure if this is possible but it would be nice to figure this one out...

 

[Teethless mama]

=INDEX(B1:B200,MATCH(TRUE,ISNUMBER(SEARCH(A1:A200,C1)),))

ctrl+shift+enter, not jsut enter