In column A2 I have this number 91-109002-000-A. In column G, I have several
109002 -000. I want to be able to compare A2 to all of G and if the
number is similar (what I call the base number), then I need for the formula
to look at column H and extract that information. So there may be more than
one answer for my extraction. Example:
(A) (G) (H)
Extraction would read
(2) 91-109002-000-A 109002-000 350574 350574,350575,643225
109002-000 350575
109002-000 643225