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

Attached Files

Test Match worksheet.xlsx (31.7 KB, 13 views)

I'm afraid that cannot be done, because the the letters in column 2 are arbitrary chosen, there is no pattern in this operation... For example, American Bar Association is ABA in column 2, in another record, all 3 letters come from the same word: Accenture is ACN... All you can do is to assign an unique ID to your records, and search after this ID to accomplish your goal.

Thanks Catalin, I figured this would be difficult. I'll have to figure out another approach.