+ Reply to Thread
Results 1 to 3 of 3

How do I set worksheet to auto input number when item selected from dropdown list.

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    Nottingham
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question How do I set worksheet to auto input number when item selected from dropdown list.

    Hi there, i've just signed up to see if anyone can help me solve this problem

    I have a drop down box on a worksheet and once I have selected the item I want from the list, I would like the price of that item to appear in the cell next to it...I have no idea how to do this, or if it's even possible, i'm sure someone out theres know a way?

    If you need more info in order to help please let me know! Thanks
    Jen

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: How do I set worksheet to auto input number when item selected from dropdown list.

    Use VLookup for that.

    You get better help if you post an excel file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: How do I set worksheet to auto input number when item selected from dropdown list.

    VLOOKUP or MATCH and INDEX
    Click on star (*) below if this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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