Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookups Help | Excel Discussion (Misc queries) | |||
Lookups | Excel Worksheet Functions | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Advanced Lookups | Excel Worksheet Functions | |||
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. | Excel Worksheet Functions |