Hello.
This is round 2.
I posted the question yesterday, and got a terrific response, but i neglected to mention one thing -
The current formula is incredible, but works on a row by row basis.
Index/Match - Return value if partial text from cell contained in separate column
however, I forgot...