Forum Discussion
Multi Column Drop Down List
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 cr...
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
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 lampsMDP00213CFLBS - MDP-00-208LED-BS PART
