+ Reply to Thread
Results 1 to 2 of 2

Thread: VLOOKUP in data valiation list?

  1. 02-01-2012, 04:44 AM #1
    KL82
    KL82 is offline
    Registered User
    Join Date
    02-01-2012
    Location
    Oslo
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question VLOOKUP in data valiation list?

    Hello! Does anybody know how I can get to the VLOOKUP in a data validation list (drop down list)?

    Eg. I have names in A2: A100 and numbers in B2: B100, my dropdown is in D2: D100 with all the numbers from
    B2:B100, When I enter a name in C2 I want to drop down in D2 should only show the numbers belonging to that name. A little hard to explain but I hope I make myself understood


    Regards.

    Kim
    Reply With Quote Reply With Quote
  2. 02-01-2012, 05:03 AM #2
    TMShucks
    TMShucks is offline
    Forum Guru TMShucks's Avatar
    Join Date
    07-15-2010
    Location
    Manchester, England
    MS-Off Ver
    MSO 2003 & 2007
    Posts
    6,223

    Re: VLOOKUP in data valiation list?

    You're talking about Dependent Drop Down Lists.

    Look at:

    http://www.contextures.com/xldataval02.html


    Regards, TMS
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0