+ Reply to Thread
Results 1 to 6 of 6

Dropdown combo in excel

  1. #1
    Registered User
    Join Date
    02-20-2014
    Location
    Accra
    MS-Off Ver
    Excel 2010
    Posts
    3

    Dropdown combo in excel

    NEED URGENT HELP!!!!!!

    Would like to know how to create a dropdown combo in excel, such that should user select from the dropdown list, excel would display a corresponding value of the selected item, rather than displaying the actual selected item.

    Sample Date

    Code Value
    101 Agriculture Loan
    102 Auto Loan

    Dropdown Combo source should be from column ‘Value’, but should user select say “Auto Loan”, combo should rather display “102” INSTEAD OF “Auto Loan”

    Many thanks

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Dropdown combo in excel

    Not entirely sure what you mean?

    Can you post the file?
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Accra
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Dropdown combo in excel

    Many thanks for the prompt response noboffinme.

    Please find attached sample file for this thread. Many thanks

  4. #4
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Dropdown combo in excel

    Hi,

    The sort of functionality you're after is probably better suited to MS Access rather than Excel.

    I've created a quick mockup of what I mean.

    The 'type of facility' field now gives you the text option to select but saves the code number to the table.

    As for locking the fields if 2 is selected Purpose of Enquiry field, I can work on this for you if you like this solution.

    Cheers
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-20-2014
    Location
    Accra
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Dropdown combo in excel

    Dear Noboffinme

    Many thanks once again for your prompt assistance. Unfortunately, the Users would have to complete in an excel and send to us, hence the need to have in Excel and not Access.

    Nevertheless, grateful for your asistance.

    Regards

  6. #6
    Registered User
    Join Date
    03-03-2014
    Location
    Kansas, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Dropdown combo in excel

    Quote Originally Posted by svantaylor View Post
    Code Value
    101 Agriculture Loan
    102 Auto Loan

    Dropdown Combo source should be from column ‘Value’, but should user select say “Auto Loan”, combo should rather display “102” INSTEAD OF “Auto Loan”

    Many thanks
    If you concatenate Code and Value you can use LEFT to lift the numeric code from the start of the string. I'm assuming you need to be able to freely update the codes and values, so I've done this sample leaving them as independent cells.

    Sample:
    Code Value ListDisplay
    101 Agriculture Loan 101 Agriculture Loan
    102 Auto Loan 102 Auto Loan


    Drop down location: A1

    In B1: LEFT(A1,3)
    And B1 will display the numeric code from the start of A1
    Last edited by semantre; 03-03-2014 at 12:01 PM.

+ 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. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  2. Replies: 0
    Last Post: 08-22-2012, 03:52 PM
  3. combo box dropdown list
    By pczmut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-29-2006, 10:15 AM
  4. [SOLVED] Combo Box List Dropdown
    By HornJM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 05:15 PM
  5. Combo dropdown open
    By mino in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2005, 11:05 AM

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