+ Reply to Thread
Results 1 to 5 of 5

Weights

  1. #1
    Registered User
    Join Date
    04-11-2005
    Posts
    48

    Question Weights

    I am trying to find a formula for vlookup and sumif.
    I am trying to build a spreadsheet for our drafting dept.
    The weights are being calculated by hand. I think it would be easier if we had a spreadsheet.

    For example, I have a channel that is C 8 x 11.5 the length is 7ft 6inch. The weight of the channel is .852 pounds per foot. I am able to calculate that in excel and come up with 86 pounds rounded. The material will change every time and the weight of the material will change every time. The length of the material will also change. I can input the length every time. What I want is to create a list where excel will do VLOOKUP and pull a different item every time something is typed in.

    I have put the spreadsheets on my web page. www.mykaltx.com.
    If you have any problem I have put my email on the web page.

  2. #2
    Registered User
    Join Date
    07-27-2005
    Posts
    4
    Still not quite sure what the list is and what the lookups are, could you add stuff to the spreadsheets on your webpage to give me a clearer view of what you are trying to do.

  3. #3
    Registered User
    Join Date
    04-11-2005
    Posts
    48

    Question Ok

    Sorry for the confusion.
    Book 3
    I updated the spread sheets. I put notes under the cells that will be affected.
    For example, if you look at item C 8 x 11.5. I will need this item on page 1 to match to the item on page 2. The item on page 2 will have a weight next to it.
    Page 2 is really a list of items that we carry.
    I know this is hard to explain. I am not good at explaining myself.
    Let me know what information you need to help me.

  4. #4
    Bob Phillips
    Guest

    Re: Weights

    see response in .excel

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "mykaltx" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I am trying to find a formula for vlookup and sumif.
    > I am trying to build a spreadsheet for our drafting dept.
    > The weights are being calculated by hand. I think it would be easier if
    > we had a spreadsheet.
    >
    > For example, I have a channel that is C 8 x 11.5 the length is 7ft
    > 6inch. The weight of the channel is .852 pounds per foot. I am able to
    > calculate that in excel and come up with 86 pounds rounded. The
    > material will change every time and the weight of the material will
    > change every time. The length of the material will also change. I can
    > input the length every time. What I want is to create a list where
    > excel will do VLOOKUP and pull a different item every time something is
    > typed in.
    >
    > I have put the spreadsheets on my web page. www.mykaltx.com.
    > If you have any problem I have put my email on the web page.
    >
    >
    > --
    > mykaltx
    > ------------------------------------------------------------------------
    > mykaltx's Profile:

    http://www.excelforum.com/member.php...o&userid=22055
    > View this thread: http://www.excelforum.com/showthread...hreadid=390611
    >




  5. #5
    Registered User
    Join Date
    04-11-2005
    Posts
    48

    Question Hey Bob

    Thanks for the help. I saw where you had put the formula under excel general.
    I have one more thing. How do I get the formula to times the qty in number of pcs?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1