Column A of my spreadsheet has several hundred "parent" part numbers.
Column C has several thousand "child" part numbers.

A parent part number is made up of a combination of characters/digits: ex.
TMCU 04-06. The length and combination of characters/digits varies.

A child part number is supposed to be made up with the parent's part number
and other characters/digits: ex. SUS-TMCU 04-06-NBR, or TMCU 04-06-D99, or
SDE-TMCU 04-06, etc. Unfortunately, these other characters/digits can be
placed before, after, or on both sides of the parent part number and vary in
length...

What I would like to do is identify all those child part numbers that have a
corresponding parent and also those child part numbers that have been
(potentially) coded wrong. Therefore, listed next to each child part
number, I would like to have (column D) the cell address of the parent and
the actual parent part number (column E). If no perfect match exists, then
there shall be (column F) the cell address of the part number in column A
that comes the closest (in terms of sequential characters/digits) to the
part number in column C, the actual part number of that cell address (column
G), and the maximum number of sequential characters/digits matched (column
H).

Thanks in advance to whoever can help me out.
--
Tiziano