+ Reply to Thread
Results 1 to 2 of 2

vlookup formula in data validation

  1. #1
    Registered User
    Join Date
    05-27-2020
    Location
    Amsterdam, Holland
    MS-Off Ver
    2010
    Posts
    1

    Lightbulb vlookup formula in data validation

    Dear forum members,

    I hope my question can be solved easily....

    I have 1 column with brands and the 2nd column with their models.
    So For Example it should look like :

    Brand Model
    A Model A1
    A Model A2
    A Model A3
    A Model A4
    B Model B1
    B Model B2
    B Model B3
    C Model C1
    etc.

    I want use 2 validation cells with the first to select the brand but then the 2nd cell should give me a pull down list with only the models of the selected brand ?
    Note that there are over 84 brands and a total of 470 models divided over all brands.


    Hope someone can help me find the easiest solution.
    Most Ideal would be that i could type in the first letters of the brand to select quicker in stead of scrolling down 84 times.

    Kind regards,

    Bert

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: vlookup formula in data validation

    See dependent drop down

+ 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: 7
    Last Post: 03-06-2015, 01:53 PM
  2. Replies: 3
    Last Post: 02-09-2015, 11:16 PM
  3. [SOLVED] Using results of a VLookup formula in Data Validation to generate a list
    By JessicaJG in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-13-2013, 03:52 PM
  4. Using either vlookup or IF formula with one Data Validation drop down
    By jagerhound in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2013, 06:24 AM
  5. Replies: 4
    Last Post: 06-26-2012, 03:53 AM
  6. Validation list & IF / VLOOKUP formula
    By tcapewell in forum Excel General
    Replies: 5
    Last Post: 08-13-2010, 12:19 PM
  7. Validation list & IF / VLOOKUP formula
    By tcapewell in forum Excel General
    Replies: 0
    Last Post: 08-10-2010, 04:16 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