Results 1 to 4 of 4

Multiple dropdown list with duplicates

Threaded View

  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

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