+ Reply to Thread
Results 1 to 5 of 5

Lookup Lists for Droip-Downs to Allow Calculations on Another Worksheet

  1. #1
    Registered User
    Join Date
    01-03-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Question Lookup Lists for Droip-Downs to Allow Calculations on Another Worksheet

    Hello,

    First time here and just need some help to create a small project.

    I run a sound and lighting company and I am in the process of cataloging all my equipment including the weight of each item.
    The next thing I want to do is add another page that I can use as a truck loading tool by being able to select items from the audio or lighting page, put in a quantity and have the page total up the weight of all the equipment so I know how much I am loading.

    How do I do this? How do I create a dropdown list of all my items on either page and have the weight associated with it so the total calculation works?

    I hope this makes sense.

    TIA

    GT
    Last edited by AliGW; 01-03-2019 at 09:32 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    West Sussex, UK
    MS-Off Ver
    365 for Mac
    Posts
    5,300

    Re: Is this possible to do?

    yes, you can use a lookup and list the items
    a sample excel sheet attached here would help

    FYI - usually a moderator would mention this - before anyone else can answer
    also you need to change your title see forum rules 1. - this would need to be a brief description of problem - before others are able to answer further
    Wayne

    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2016 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    23,676

    Re: Lookup Lists for Droip-Downs to Allow Calculations on Another Worksheet

    Welcome to the forum!

    This forum requires you to use more informative thread titles. Please see the amendment I have made for you this time to see the sort of thing we expect in future.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    Are you new to Power Query and don't know what to do with the code you've been given? Have a look here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    01-03-2019
    Location
    Brisbane, Australia
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Lookup Lists for Droip-Downs to Allow Calculations on Another Worksheet

    Thank you for the help and I apologise for my poor description.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    6,448

    Re: Lookup Lists for Droip-Downs to Allow Calculations on Another Worksheet

    To upload a sample spreadsheet, as Wayne suggests, click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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