How to fill in multiple cells from a dropdown list

**AMcRae** · 03-08-2013, 09:02 AM

Hi All

I am currentley trying to create a cost sheet for materials & labour from a materials drop down list, is there a way to fill in the material & labour cost columns depending on the materials selected. I have attached the excel file and need to fill in the details in the cost breakdown sheet from the data sheet.

Thanks in advanceTemplate, PV Installations.xlsx

**Sean Thomas** · 03-08-2013, 09:24 AM

Hi i have done the fist row for you you just need to copy the formula and make the changes required

**dilipandey** · 03-08-2013, 09:27 AM

Hi AmcRae,

Since part number is different in data sheet, You can use below formula:-
=VLOOKUP($E6,'Data Sheet'!C:D,2,0)

in column F of CostBreakdown sheet.

Regards,
DILIPandey
<click on below * if this helps>

**mkbeyeler** · 03-08-2013, 10:45 PM

I am having similar issue. Wanting to cells to auto fill depending on what is chosen from the drop down menu. I have attached the excel document. I have the dealer name drop down and want the dealer ID number and State to fill in automatically once dealer name is entered. I have tried =IF and =VLookup. I have the dealer info on Sheet 2 "Dealers". Thanks in advance for your help! Much appreciated.
Mini Lite Order Form-Formulas.xlsm

**dilipandey** · 03-10-2013, 07:12 AM

Hi Mkebeyeler,

welcome to the forum. Please start your own thread rather than posting in someone else's thread.
see the forum rules;-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey
<click on below * if this helps>