Multi Column Drop Down List

[Michele2800]

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

[#2]

@Michele2800 

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

[#3]

Please attach your sample file.

[#4]

@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-BS

PART