VLOOKUP issue from drop down list, Please Help

[oshier]

Hi I am trying to create a Excel service invoice for our sign shop, I started with a pre-made template I downloaded from Excel 2013 named "Service Invoice", for the most part this form is exactly what we need the way it is. The only thing I yet need to accomplish which I do not know how to do is the following.

I have attached a copy of the form for you to look over, I have it set up so that under Parts Used section you need to manually insert the Quantity and under Part Description column I am using a drop down list which pulls from the Materials List sheet using the Data Verification method from cells A of that sheet, under the Price column it is currently set to manually insert a price and what I am trying to accomplish is to be able to when I choose a item from the drop down list to automatically insert the related price point from cells B to be placed in the Price column of the Service Invoice form automatically when that item is chosen from the drop down list and still have the existing auto sum formulas in the Price and Amount columns to continue to calculate as they do.

I would appreciate any help on this I can get, Thanks in advance for your time.

Thanks
Bill

[oeldere]

I22=IFERROR(VLOOKUP($C22,'Material List'!$A$1:$B$5,2;0),"")

J22=IFERROR(B22*I22,"")

and drag down.

See the yellow cells in the attached file.

[oshier]

Thank you so very much, that is exactly what I needed it to do, I appreciate all your time, Have a Blessed Day!