Formula Help - multiple cells contain different values based on table, return value

[kswny0775]

I need a formula to validate data based on the sample below. But fields can contain multiple values when searching for through original and new and then needs to use a look up table as well.
Best I can explain using the sample below is trying to return True or False on:

If Area Old contains "Misc" and Area New contains the correct value based on the table, return TRUE/FALSE

 

[sijpie]

You can check if a word is in a piece of text using SEARCH() formula. This formula will return the start of the search item as a number, or an error if not found. By checking for the error using ISERROR() you will get a TRUE if it is not there or a FALSE if it is there. So use NOT() to reverse TRUE/FALSE. And a simple VLOOKUP() to find the area belonging to the Owner

Formula in I1:
=NOT(ISERROR(SEARCH(VLOOKUP(F2,$A$3:$B$12,2,FALSE),H2)))