Help with using vlookup and acting on the results

[Ralph2]

Hello
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

 

[Michael Bednarek]

Hello
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.

I may not quite understand what you need, but have you tried:
=CEILING(A12*E12/10,1)

 

[Ralph2]

Thanks to anyone who tried to figure this out. Problem solved using
the Int(a2*1.1) function