I have four columns: Column A has a part number, column B has a new price Column C has a part number, column D has an old price. Column A and C are not identical nor do they have the same number of ...
Is there a formula or script that will match sub-strings from one column in another column and return the full value of the sub-string match? e.g. Input COL_a COL_b name ...