Match information from 2 different columns

[gbaker]

Hello all,

Is there a way to match information from one column in an array to something from another column in an array:


Column 1 = acs-pc is part of the array in column 1, Could be anywhere in the column.

Column 2 = acs is part of the array in column 2, Could also be anywhere in the column.

Is there a formula or some other way to accomplish this.

Let me know if this is clear enough. I am attaching a worksheet.

Thanks GWB