+ Reply to Thread
Results 1 to 3 of 3

Drop Down List with Linked Column

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Drop Down List with Linked Column

    Hi there:

    In my Sheet 1, in Column B I have a drop down list to select a name. I have used the data validation to select the name list from Sheet 4 that also has two more column associate with it, i.e., name code and group code. I am looking for way to show all three columns in Sheet 1 when I select the name from drop down menu in Sheet 1. I already have blank column next to name column with drop down.

    Sheet 1
    Name NameCode GroupCode

    Sheet 4
    Name NameCode GroupCode

    Thank you in advance.

    Paul
    Last edited by paulofabingdon; 06-12-2014 at 11:23 AM.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,460

    Re: Drop Down List with Linked Column

    Use a VLOOKUP formula to lookup the selected name and return the two codes e.g.

    C1 (NameCode)
    =VLOOKUP(B1,Sheet4!A:C,1,0)

    D1 (GroupCode)
    =VLOOKUP(B1,Sheet4!A:C,2,0)

    Change the lookup columns A:C to suit.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    06-12-2014
    Posts
    2

    Re: Drop Down List with Linked Column

    Thank you! Great. It worked.

    Puru

+ 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. Word drop down list linked with excel
    By Didec in forum Word Formatting & General
    Replies: 1
    Last Post: 09-23-2011, 02:03 PM
  2. Cell to display price when linked to drop down list
    By Solo Sails in forum Excel General
    Replies: 2
    Last Post: 06-27-2011, 03:50 PM
  3. Input data automatically linked to drop down list
    By Greybeard101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2011, 11:23 AM
  4. linked drop down list boxes and external source
    By haggisns in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2010, 03:07 PM
  5. Updating of cell linked to drop-down list
    By zalcjm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2006, 04:40 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