A bit more info on the problem. The RC WWID is the lookup value, while the output values will fall under the Sub WWID's columns. The Lookup and Output values are located in a seperate sheet than the data array.

ColA ColB ColC ColD ColE
RC WWID Sub WWID's
MM585 AAXXX AAXXX
ES315 AAXXX AAXXX AAXXX AAXXX
JM941
KK938 AAXX AAXXX AAXXX