#1   Report Post  
Old June 17th 11, 04:29 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 2
Default 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   Report Post  
Old June 17th 11, 04:35 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2011
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookups Help FT Excel Discussion (Misc queries) 2 March 17th 09 07:08 PM
Lookups John[_5_] Excel Worksheet Functions 4 May 28th 07 05:58 PM
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) shadestreet Excel Discussion (Misc queries) 2 July 21st 06 03:04 PM
Advanced Lookups Steve ([email protected]) Excel Worksheet Functions 3 July 25th 05 03:39 PM
LOOKUPS - Creating LOOKUPs where two different values must BOTH be satisfied. Mr Wiffy Excel Worksheet Functions 2 May 16th 05 04:29 AM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017