I apologize for the confusion- I thought I explained it better- at least it sounded good in my head- I clearly was more confused than I originally thought.


The result I need looks identical to the pivot table that gebobs showed-
that thought never crossed my mind- I figured indirect was the way to go, since vlookup/hlookup wouldn't work since there were program numbers were not specific to each part number.
I will give a pivot table a try and see if it will merge everything together.

Thank you everyone!!