×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Help with vlookup and acting on that result

Help with vlookup and acting on that result

Help with vlookup and acting on that result

(OP)
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
 

 

RE: Help with vlookup and acting on that result

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/
 

RE: Help with vlookup and acting on that result

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources