Jul 02 2019 12:58 PM
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-BS | PART | PART # | CUSTOMER COST |
SHADE | OM05072000 | $179 | ||
ASSYSKT-MED PEND | SA05009900 | $26 | ||
STEM KIT | 94862413 | $13 | ||
INSERT - HSG WEDGE | CT00151300 | $6 | ||
LENS | DP05002300 | $29 | ||
LAMP (X2) | LM05010402 | $17 |
Jul 02 2019 01:40 PM
If you have somewhere in workbook mapping of parts, part numbers and cost
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
Jul 02 2019 02:16 PM
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-BS | PART |