Help with vlookup and acting on that result 1

[Ralph2]

I am trying to make a simple purchase spread sheet. Using a pick list I pick my part number. This in turn using vlookup fills in details such as description and our stock code. This part is working well.
But.. I want to be able to input the number pieces that will be translated into the length of material we will need. AND for every 10 pieces need to add one.
So my spread sheet has;
Amount: Part#: Description: Stock Code: Total inches:
My drop down pick list selects the part# and my vlookup fills in Description with =IF(B12=0,"",VLOOKUP(B12,'PN & Desc'!A4:C52,3,FALSE)) and =IF(B12=0,"",VLOOKUP(B12,'PN & Desc'!A4:C52,3,FALSE))fills in the stock code.
My Total Inches is filled with =IF(A12=0,"",VLOOKUP(B12,'PN & Desc'!A4:E52,4,FALSE))
So my problem now is how do I multiply this value by the value in Amount AND add one length for every ten units.

If this makes sense.. any help would be most appreciated.

Thank you for your time

 

[IDS]

Not really a vlookup problem.

If you had the number of pieces in A1 then =Int(A1*1.1) will add one extra piece for every 10. Just multiply that by the unit length.

Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[Ralph2]

Thank you IDS.. exactly what I needed. I knew there had to be a simple way... you should have seen my effort(s) very convoluted and it did not work consistently.
Thanks again