+ Reply to Thread
Results 1 to 2 of 2

Autocomplete based on a different column

  1. 01-01-2008, 03:20 AM #1
    DDR2
    DDR2 is offline
    Registered User
    Join Date
    01-01-2008
    Posts
    4

    Autocomplete based on a different column

    I have an excel spreadsheet that lists names (Column A) and pager numbers (Column B) on a worksheet say worksheet2.

    On another worksheet I use VLOOKUP to lookup the pager number for a name that is entered into a cell.

    Is there a way that I can get autocomplete to work so that
    when someone enters the first few characters of the name in a specific cell, excel uses autocomplete to complete the name using the column "name" on worksheet2. Is it possible to get the possiblities show as a dropdown list - just like the way intellisense works in Visual studio?
    Reply With QuoteRegister To Reply
  2. 01-01-2008, 04:33 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    You can't really achieve that, however you can use Data Validation to create a drop down list to choose from.

    http://www.excel-it.com/data_validation.htm

    If you want to use VBA you could use a ComboBox, which has an autocomplete function.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
+ 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.6.0 RC 1