Gentlemen, I've redone the entire post.
The similar link mentioned before is:
The more accurate question is how do I use Column 1 of Sheet2, here:
... to find a match of a project ID here:
... so that I get this end result:
The problem with Edit | Fill Down is obvious ... D5 is the cell to modify for the first of 26 projects, D9 is the next. I'll need to find a column/row reference by Project ID match more than likely.
I've looked at VLOOKUP(), SUBSTITUTE(), REPLACE(), SEARCH() which all seem to be pieces of the solution. An option open to me is to use VSTO since C#.Net I'm much more familiar with. Very easy to search a string in C# for a match from the 2nd worksheet | Column 1, etc. Those desiring the solution prefer VBA or a Macro or formula.
Hope I'm more to the point this time.