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
Highlighted
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
Highlighted

@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

Highlighted
Please attach your sample file.
Highlighted

@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