Advanced Lookups
 

I am trying to create a hierarchy based on the data below. I would like to lookup the value in ColK and return the corresponding variables in Col's L thru O.

Ex) Lookup JM 941--KE049
Lookup AR786-- HQ967, IL003, BG873, KE852, AO105, FL535,CQ931,KE416,JC525,HB429,DC820,JZ442,FB097,II 423, CL401,KD463


ColK ColL ColM ColN ColO
JM941
JM941 KE049
KK938
KK938 HX978
KK938 II315

AR786
AR786 HQ967
AR786 IL003
AR786 IL003 BG873
AR786 KE852
AR786 AO105
AR786 AO105 FL535
AR786 AO105 FL535 CQ931
AR786 AO105 FL535 CQ931 KE416
AR786 AO105 FL535 CQ931 JC524
AR786 AO105 FL535 HB429
AR786 AO105 FL535 HB429 IE422
AR786 AO105 FL535 HB429 JR129
AR786 AO105 FL535 DC820
AR786 AO105 FL535 JZ442
AR786 AO105 FB097
AR786 AO105 II423
AR786 AO105 II423 CL401
AR786 KD463
OO337
DK778

Not sure if this is possible using excel formula or not, but any help will be appreciated!

Brian

Advanced Lookups
 

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