+ Reply to Thread
Results 1 to 4 of 4

Cell auto fill based on another field drop down list selection

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2013
    Posts
    15

    Question Cell auto fill based on another field drop down list selection

    Hello, i have a problem - can someone tell me how to auto fill 2 other cells if i select one record in one cell from drop down list. I know only how to do it with "if" function but it is very slow and uncomfortable cause i have huge amount of information and it doesnt work when i choose information from another sheet.

    For example, i choose in a1 employee from drop down list (all employees, their IDs and job titles are in other sheet) and i need to fill a2 and a3 with the corresponding ID and job title.

    Thanks.

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Cell auto fill based on another field drop down list selection

    you can either use vlookup() or index() with match(). Please post a sample work book if you need any more help.

  3. #3
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Cell auto fill based on another field drop down list selection

    See my sample attached.

  4. #4
    Registered User
    Join Date
    03-21-2012
    Location
    Riga, Latvia
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Cell auto fill based on another field drop down list selection

    Thanks, vlookup() function worked almost perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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