# Excel - Help with using vlookup and acting on the results

Asked By Ralph2 on 29-Apr-12 01:39 PM
```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
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.

Michael Bednarek replied to Ralph2 on 29-Apr-12 09:45 PM
```microsoft.public.excel:

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

--
Michael Bednarek                           "ONWARD"```
Ralph2 replied to Ralph2 on 30-Apr-12 12:09 AM
```Thanks to anyone who tried to figure this out. Problem solved using
the Int(a2*1.1)  function```