+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP drop down list

  1. #1
    Registered User
    Join Date
    02-01-2017
    Location
    Lisboa
    MS-Off Ver
    2010
    Posts
    81

    VLOOKUP drop down list

    Hello,

    I would appreciate some help with a problem I am trying to solve.

    I have a table with the information of the materials of some products (A1:D). Some products can have more than 1 material.

    I would like to make a drop-down list in a column of another table, that once the user insert the “Product ID”, the drop down list only shows the multiples results of that specific product.

    Any suggestions would be greatly appreciated

    Thank you in advanced.
    Attached Files Attached Files
    Last edited by PaulaGon; 11-26-2020 at 02:49 PM. Reason: attached file

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: VLOOKUP drop down list

    Please try Data validation list

    =OFFSET($D$1,MATCH(H2,$A$2:$A$16,),,COUNTIFS($A$2:$A$16,H2))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-01-2017
    Location
    Lisboa
    MS-Off Ver
    2010
    Posts
    81

    Re: VLOOKUP drop down list

    Hello Bo_Ry,

    After adapt you formula in "Data validation list" in my original worksheet it works exactly as I need.

    A thousand thanks for your help!!!

+ 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. Vlookup to chose correct list depending on a drop down list selection
    By Bandit_750 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-06-2015, 06:22 PM
  2. [SOLVED] VBA vlookup drop down list
    By rs1aj in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-21-2014, 12:52 PM
  3. Two drop down list and VLOOKUP
    By Devi Suryani in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-18-2013, 02:46 AM
  4. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  5. Can I add a drop-down list to a Vlookup?
    By dsharb52 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2006, 06:35 PM
  6. [SOLVED] Can I add a drop-down list to a Vlookup?
    By dsharb52 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-11-2006, 05:50 PM
  7. Drop Down List + VLOOKUP
    By Bonbon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2006, 12:45 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