Vlookup or Instring with a lookup Table

Can someone help, I have a lookup table and I'm just trying to figure what action will allow me to do a instring type function. I can only get action lookup to work if the value in the main table matches the lookup table exactly, when I need it to show also when the text contain is included in the string.

Yes, "Lookup" only does exact matching. The solution is to use the "Match" action before "Lookup", because the "Match" action has other match modes - contains, starts with, ends with, fuzzy. So you match first, and then do a lookup for the matched value.

See the example below:
lookup-contains.morph (3.3 KB)