Home

Multi Column Drop Down List

%3CLINGO-SUB%20id%3D%22lingo-sub-735127%22%20slang%3D%22en-US%22%3EMulti%20Column%20Drop%20Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735127%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20beginner%20with%20excel%20and%20trying%20to%20create%20a%20drop-down%20list.%20I%20want%20the%20user%20to%20be%20able%20to%20click%20on%20a%20part%20and%20the%20specific%20part%20%23%20and%20cost%20will%20populate%20with%20it.%20I%20figured%20out%20how%20to%20create%20a%20simple%20drop%20down%2C%20I'm%20just%20having%20issues%20with%20how%20to%20get%20the%20other%20data%20in%20with%20it.%20below%20is%20an%20example%20of%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20user%20clicked%20on%20parts%20and%20selected%20%22Shade%22%20I%20want%20the%20Part%20%23%20-%20OM05072000%20and%20Cost%20%24179%20to%20pull%20up%20with%20the%20selected%20part.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20all%20and%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDRUM%20PENDANT-MEDIUM%2C%20WHITE%3CBR%20%2F%3ELarge%20drum%202-lamp%20pendant%2C%20white%20shade%20(inside%20and%20outside)%20with%20LED%20lamps%3C%2FTD%3E%3CTD%3EMDP00213CFLBS%20-%20MDP-00-208LED-BS%3C%2FTD%3E%3CTD%3EPART%3C%2FTD%3E%3CTD%3EPART%20%23%3C%2FTD%3E%3CTD%3ECUSTOMER%20COST%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESHADE%3C%2FTD%3E%3CTD%3EOM05072000%3C%2FTD%3E%3CTD%3E%24179%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EASSYSKT-MED%20PEND%3C%2FTD%3E%3CTD%3ESA05009900%3C%2FTD%3E%3CTD%3E%2426%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ESTEM%20KIT%3C%2FTD%3E%3CTD%3E94862413%3C%2FTD%3E%3CTD%3E%2413%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EINSERT%20-%20HSG%20WEDGE%3C%2FTD%3E%3CTD%3ECT00151300%3C%2FTD%3E%3CTD%3E%246%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ELENS%3C%2FTD%3E%3CTD%3EDP05002300%3C%2FTD%3E%3CTD%3E%2429%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3ELAMP%20(X2)%3C%2FTD%3E%3CTD%3ELM05010402%3C%2FTD%3E%3CTD%3E%2417%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-735127%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735175%22%20slang%3D%22en-US%22%3ERe%3A%20Multi%20Column%20Drop%20Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735175%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F370142%22%20target%3D%22_blank%22%3E%40Michele2800%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20have%20somewhere%20in%20workbook%20mapping%20of%20parts%2C%20part%20numbers%20and%20cost%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20556px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121968iDED68708187FCFD8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20B%20cells%20are%20with%20drop%20down%20list%2C%20you%20may%20use%20in%20C2%3C%2FP%3E%0A%3CPRE%3E%3DINDEX(%24G%242%3A%24G%247%2CMATCH(%24B2%2C%24F%242%3A%24F%247%2C0))%3C%2FPRE%3E%0A%3CP%3Esimilar%20in%20D2%20and%20drag%20them%20down%20till%20end%20of%20the%20range%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735176%22%20slang%3D%22en-US%22%3ERe%3A%20Multi%20Column%20Drop%20Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735176%22%20slang%3D%22en-US%22%3EPlease%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-735241%22%20slang%3D%22en-US%22%3ERe%3A%20Multi%20Column%20Drop%20Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-735241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20I%20fully%20follow.%3C%2FP%3E%3CP%3EI%20would%20like%20the%20table%20only%20to%20show%20the%20three%20columns%20with%20Parts%20being%20the%20drop%20down.%26nbsp%3B%20From%20there%20it%20shows%20the%20different%20parts%20available%20-%20Shade%2C%20Stem%20kit%2C%20Lens%2C%20etc.%20So%20when%20you%20click%20on%20the%20part%20needed%20it%20will%20populate%20the%20correct%20part%20%23%20and%20price.%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDRUM%20PENDANT-MEDIUM%2C%20WHITE%3CBR%20%2F%3ELarge%20drum%202-lamp%20pendant%2C%20white%20shade%20(inside%20and%20outside)%20with%20LED%20lamps%3C%2FTD%3E%3CTD%3EMDP00213CFLBS%20-%20MDP-00-208LED-BS%3C%2FTD%3E%3CTD%3EPART%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E
Michele2800
New Contributor

Hi,

 

I am a beginner with excel and trying to create a drop-down list. I want the user to be able to click on a part and the specific part # and cost will populate with it. I figured out how to create a simple drop down, I'm just having issues with how to get the other data in with it. below is an example of the list.

 

If the user clicked on parts and selected "Shade" I want the Part # - OM05072000 and Cost $179 to pull up with the selected part.  

 

Thanks in advance for all and any help!

 

DRUM PENDANT-MEDIUM, WHITE
Large drum 2-lamp pendant, white shade (inside and outside) with LED lamps
MDP00213CFLBS - MDP-00-208LED-BSPARTPART #CUSTOMER COST
  SHADEOM05072000$179
  ASSYSKT-MED PENDSA05009900$26
  STEM KIT94862413$13
  INSERT - HSG WEDGECT00151300$6
  LENSDP05002300$29
  LAMP (X2)LM05010402$17
3 Replies

@Michele2800 

If you have somewhere in workbook mapping of parts, part numbers and cost

image.png

and B cells are with drop down list, you may use in C2

=INDEX($G$2:$G$7,MATCH($B2,$F$2:$F$7,0))

similar in D2 and drag them down till end of the range

Please attach your sample file.

@Sergei Baklan 

I'm not sure I fully follow.

I would like the table only to show the three columns with Parts being the drop down.  From there it shows the different parts available - Shade, Stem kit, Lens, etc. So when you click on the part needed it will populate the correct part # and price. 

DRUM PENDANT-MEDIUM, WHITE
Large drum 2-lamp pendant, white shade (inside and outside) with LED lamps
MDP00213CFLBS - MDP-00-208LED-BSPART
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies