SOLVED!!! Drop down box choice to populate next 2 cells.

I have read through the majority of the posts and replies for help on this same topic. But for the life of me, I can't get it to do what I need it to do. I'm to the point of pulling my hair out!!! I'm a fairly new Excel 2010 user, and I've attached my file with the information, and descriptions. Hoping you can help!!! Thanks for your time.

First, I defined two ranges. The easiest way to do this is to select the range and then type a name (no spaces) into the "name box" (little white box in upper left which usually has your Cell id in it, i.e. "A1")

Equipment = sheet2!A2:A28
DataTable = sheet2!A2:C28

Then you need to use Data Validation
Select your range (Sheet1!A2:A30), then Data Validation (on Data tab)
>Allow List
>Source = Equipment
OK

Then in B2 of sheet1
=IF(ISTEXT($A2),VLOOKUP($A2,DataTable,COLUMN(B$1),FALSE),"")
copy that formula into C2 and all the way down in both columns.

Questions?

Ok, I have to say thank you again for all your help!!! But now I need an additional column in the mix here... see attached.... Sorry.. was having trouble getting the new chart attached.

Not sure I'm following. You cannot have a column with a dropdown box AND a formula that multiplies that number by other columns. You'll need two columns, one for 1-10 and one for the formula
=IF(ISNUMBER(D3), B3*D3*E3,"")