Results 1 to 4 of 4

Thread: Drop Down List

  1. #1

    Drop Down List



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have Item Name n one column and Item code in second column in Sheet2.
    I would like to create drop down list in Sheet one. View both columns information in drop down list in the sheet1 drop down list and select and write any only one column value.
    Example: View Apple 100 in drop down list in sheet one and able to select and write Item code 100 in the cell


    Example:


    Item Name Item Code
    Apple100

    Mango101

    Orange102

    Banana103



    Note: My actual Item list is long -say about 50 Items an with code So for easy entry, need search function if possible



    I would like to see Item name with code in drop down list and write only the tem code in the cell.


    I would like the drop down list without using Code / VBA as I o not know much about VBA



    Would any one help me?


  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    If you want to return only the item code in the same cell as the dropdown after selection, you will need some vba

    Check for sample here:

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

    Under Data Validation, look for 'DV0005 - Data Validation "Columns"'

    If you can put the result in a separate cell after selection, then you won't necessarily need VBA. You can combine the tables in Sheet2, use that new column in your Dropdown List, then do an Index/Match in a separate cell to return only the code associated.


  3. #3

    Drop Down List

    Thank you very much for your help.

    I will go through the link and leran.

    Best regrads

    Shishir

  4. #4
    Can we retain the format of the text in origin data. Means if the text are in bold / italic / red or green in color, etc?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •