+ Reply to Thread
Results 1 to 3 of 3

Create data validation based on lookup to get a list

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Create data validation based on lookup to get a list

    Hi,
    I try to create a dada validation list using vlookup based on the value in H11, then find a range
    of 3 values from (3) cells. I play around but not working.

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Create data validation based on lookup to get a list

    see this attachment

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Create data validation based on lookup to get a list

    Thanks. It works.

    Can the validation list update and refresh to match the list for the value in H11?
    For example, in H11, if I slect "1", then the validation list should automaticly
    update to the first item "organge" for that list instead of "A" and has to pick the
    correct one.

    Thanks
    the one.

+ 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. Create validation list based on a cell value
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2013, 10:44 PM
  2. Replies: 3
    Last Post: 05-23-2013, 06:23 AM
  3. [SOLVED] Create Dynamic Data Validation List based upon Criteria
    By stubbsj in forum Excel General
    Replies: 6
    Last Post: 06-04-2012, 08:33 AM
  4. Replies: 4
    Last Post: 02-15-2012, 12:11 PM
  5. Lookup Value based off Data Validation List / Populate Form
    By snake10 in forum Excel - New Users/Basics
    Replies: 13
    Last Post: 03-22-2009, 02:57 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