+ Reply to Thread
Results 1 to 4 of 4

Data fill to another cell based on the item selected from drop down list

  1. #1
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Data fill to another cell based on the item selected from drop down list

    Hi,

    I have invoice format in excel. What i want to make is when i select the code of the menu item from dropdown list. the corresponding item should fill the items cell and price cell too.

    Example attached.
    Attached Files Attached Files

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data fill to another cell based on the item selected from drop down list

    Try this...

    Do this first...

    Unmerge the cells D5:E5.

    Entered in D5 and copied across to E5:

    =IFERROR(VLOOKUP($C5,Sheet2!$A$2:$C$5,COLUMNS($D5:D5)+1,0),"")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    06-17-2014
    Location
    Male'
    MS-Off Ver
    Office 2010
    Posts
    31

    Re: Data fill to another cell based on the item selected from drop down list

    Thank you very much.
    That works fine.

    one more question. If i have a long list in drop down menu, i want to search the item by entering the first letter of the item in the keyboard i am looking for. Is this possible?

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Data fill to another cell based on the item selected from drop down list

    Possible, but kind of a kludge!

    Sort your list like this...

    Data Range
    A
    1
    A
    2
    Albo
    3
    Allco
    4
    B
    5
    Besm
    6
    Bibs
    7
    C
    8
    Clep
    9
    Clinker
    10
    D
    11
    Dopa
    12
    Drip


    Then, when you setup the drop down list goto the Error Alert tab.

    Uncheck: Show error alert after invalid data is entered

    Now, when using it on the worksheet if you click on the cell and type in a letter like B (don't hit enter) then click the down arrow the list will automatically scroll to the letter B. From there you can scroll to your specific selection.

+ 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. Macro to pull all rows of data based on an item selected in drop down
    By owensjb2 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-14-2015, 10:35 AM
  2. Replies: 1
    Last Post: 10-04-2015, 05:09 AM
  3. Display multiple value when item selected in drop down list
    By peter.lu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-15-2015, 05:06 PM
  4. Replies: 1
    Last Post: 08-13-2015, 11:57 AM
  5. Replies: 4
    Last Post: 06-16-2015, 12:27 PM
  6. Run macro when item from drop-down list is selected
    By barnett2000 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-09-2013, 12:52 PM
  7. How to get index of selected item in drop down list?
    By nleahcim in forum Excel General
    Replies: 3
    Last Post: 08-08-2011, 02:08 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