+ Reply to Thread
Results 1 to 4 of 4

Link Numbers to Items in a drop down list?

  1. #1
    Registered User
    Join Date
    02-23-2021
    Location
    Green Bay, Wisconsin
    MS-Off Ver
    19
    Posts
    2

    Link Numbers to Items in a drop down list?

    I want to set up a spreadsheet to track my calories.
    Screenshot (305).png

    I was wondering if I could tie the 500 to the eggs and 600 to the oatmeal. More specifically I want to know if its possible for the calories to autofill when I select an item from the dropdown list. For example if I only eat eggs then when I select eggs in the drop down menu I want 500 to display in the calories. If I were to select oatmeal as a second food item then I'd like 1100 to autofill in the calories box. Is this possible using excel? Thanks!
    Attached Files Attached Files
    Last edited by bobsvegene; 02-23-2021 at 10:02 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Link Numbers to Items in a drop down list?

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    02-23-2021
    Location
    Green Bay, Wisconsin
    MS-Off Ver
    19
    Posts
    2

    Re: Link Numbers to Items in a drop down list?

    just added it!

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Link Numbers to Items in a drop down list?

    create a table with all your food items and the calories of each. Then use Vlookup for each item to get the calories from the look up table.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 11-26-2020, 01:51 PM
  2. Replies: 0
    Last Post: 04-22-2014, 11:03 PM
  3. Items used from a drop down list
    By vanmeterkj in forum Excel General
    Replies: 3
    Last Post: 05-17-2012, 01:50 AM
  4. User Form List items to link to other sheets in the workbook
    By ravergirl7216 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2010, 02:00 PM
  5. Replies: 3
    Last Post: 07-03-2010, 03:45 AM
  6. [SOLVED] how do I link a drop down list entry to a new drop down cell?
    By lmunzen in forum Excel General
    Replies: 1
    Last Post: 08-15-2006, 12:05 PM
  7. [SOLVED] how do i link a list of items in a workbook to worksheets in the .
    By Camalla in forum Excel General
    Replies: 2
    Last Post: 04-22-2005, 05:06 PM

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