+ Reply to Thread
Results 1 to 4 of 4

Multiple dropdown list with duplicates

  1. #1
    Registered User
    Join Date
    05-18-2021
    Location
    Franeker
    MS-Off Ver
    MS Office 2016
    Posts
    9

    Question Multiple dropdown list with duplicates

    Hi all,

    We are working on a meal planning application in excel, but are facing a problem. Our main goal is to select an ingredient and unit so that it returns the right number of calories. However, due to duplicate values in the row with units, it returns the wrong number of calories.

    The ingredient can be chosen in G3, which uses data from row E, which itself uses data from row A (minus duplicates). No problems are seen here.
    The unit can be chosen in H3, which doesn’t cause any problems as well.
    The next step is problematic for us. Because of duplicate units (for example ‘100 gram’), we only get the corresponding calories of the top selection. I’ve tried solving the problem with VLOOKUP and OFFSET/MATCH functions but can’t seem to figure it out.

    Hopefully someone can help us out. Much thanks in advance!

    Renzo

    P.S. The data in this file is fictional, as we've created it as example
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Multiple dropdown list with duplicates

    Formula in I3
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Must be entered by pressing Ctrl+Shift+Enter
    Attached Files Attached Files
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    05-18-2021
    Location
    Franeker
    MS-Off Ver
    MS Office 2016
    Posts
    9

    Re: Multiple dropdown list with duplicates

    This is exactly what I was looking for, thank you so much for the clear and fast answer!

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Multiple dropdown list with duplicates

    Pleasure...Tx for rep +

+ 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] Removing Duplicates from Dropdown List
    By bashscript in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 04-21-2021, 12:35 PM
  2. Replies: 5
    Last Post: 11-15-2018, 11:02 AM
  3. Replies: 1
    Last Post: 11-21-2017, 01:55 PM
  4. Make same selection for multiple drop down list and clear all for all dropdown list
    By salomip13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-30-2014, 01:34 PM
  5. multiple dropdown list
    By allgeef in forum Excel General
    Replies: 7
    Last Post: 03-23-2011, 09:14 PM
  6. Dropdown list effects multiple dropdown list
    By pvaldez in forum Excel General
    Replies: 1
    Last Post: 05-07-2010, 02:12 PM
  7. Replies: 21
    Last Post: 12-02-2009, 03:27 PM

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