Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Is it possible to import from a worksheet or create a multiple column list?
    If so, Is there a maximum # of columns and rows you can have. I understand that NUMBERS should be formatted as text.

    such as:

    Code # Description # of employees

    123 Dept A 10
    324 Dept B 15
    536 Dept C 5



    Thank you

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I have no idea what you actually mean by this. Care to elaborate?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    386
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I am attaching a worksheet with 3 colums and 4 rows. the first row is the description of the each field.

    I would like a drop down list with the DEPT # - DEPT NAME - DEPT EMPLOYEE COUNT. Better yet is there a way without getting into VLOOKUP to select the DEPT # and the DEPT NAME and DEPT EMPLOYEE COUNT populate automatically.

    Attached Files Attached Files

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How does this work?
    It uses a control toolbox combobox to display all 3 columns, the first column is then filled in, the 2nd and 3rd columns use VLOOKUP (I am not sure why you don't want to use it, it seems to me the best way without resorting to code...)

    Steve
    Attached Files Attached Files

  5. #5
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Here is another alternative. It is ideal to use a Validation List along with VLOOKUP for the example data given to us.

    Click the arrow in cell E2 to pick a valid DEPT# and then cells F2 and G2 will show the results for that choice.
    Cell E2 drop down arrow shows only valid DEPT#'s.
    Attached Files Attached Files

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It is ideal to use a Validation List along with VLOOKUP for the example data given to us.
    [whisper]The validation list does not allow for the display of multiple columns which was one of the criteria...

    Steve

Posting Permissions

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