+ 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
    MS-Off Ver
    MS Office 365
    Posts
    19,385

    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.

  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
    MS-Off Ver
    MS Office 365
    Posts
    19,385

    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. Replies: 1
    Last Post: 08-15-2006, 12:05 PM
  7. 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