+ Reply to Thread
Results 1 to 3 of 3

Drop-down list and respective data display

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Austria
    MS-Off Ver
    Excel 2011
    Posts
    1

    Question Drop-down list and respective data display

    Hi Experts,
    thanks for reading into my case!

    I am currently working on a nutrition plan and meal calculator. For this I have a table of a few hundred foods including their nutrition facts, which are divided into different columns in the respective row of the food item.
    What I am looking for is a way to 1) select the food item on another work sheet in a drop-down list AND 2) let the respective nutrition facts be displayed besides.

    This could look like that:

    | | = 1 cell
    1. Row (headline): |Food item|Amount (g)|Energy (kcal)|Protein (g)|…etc.
    2. Row: |Drop-down list with food items (auto-complete)|100|398|25|…etc.
    3. Row: ----||----
    4. Row: ----||----
    5. Row: ----||----
    6. Row: ----||----
    7. Row: ----||----
    8. Row: |Sum:|450|2345|150|...etc.

    The numbers in the second row should adjust according to the food item selected. Row 3 to 7 should look like the second row.

    It would be already very helpful if you could just point me into the right direction, as my limited excel vocabulary doesn't allow a very specific search (I do have used it before! ). Thank you very much!

  2. #2
    Valued Forum Contributor Dunc3142's Avatar
    Join Date
    09-05-2007
    Location
    Franklin OH
    MS-Off Ver
    2000 and 2007 and 2010 @ Home & Teach 2010
    Posts
    351

    Re: Drop-down list and respective data display

    If you could attach just the table or part of the table I think I can help you.
    Yes it will. we just have to figure out how...
    If I have helped you, PLEASE click the * and add to my Rep.
    Also, if the problem is SOLVED please mark it as so.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Drop-down list and respective data display

    Hi and welcome to the forum

    For the drop-down, take a look at Data Validation - use LIST and make the necessary part of the table your range

    for the other cells, take a look at using the VLOOKUP() function
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. [SOLVED] Update respective cell values in the table based on Multiple Drop Down list selections.
    By nileshpatil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-16-2012, 09:30 AM
  2. [SOLVED] Update respective cell value based on Multiple Drop Down list selections
    By nileshpatil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-16-2012, 08:43 AM
  3. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  4. Replies: 4
    Last Post: 06-07-2012, 10:04 AM
  5. Data Validation Drop Down List Display
    By laundry125 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-28-2008, 01:20 AM

Tags for this Thread

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