+ Reply to Thread
Results 1 to 3 of 3

Drop Down Menu with Dynamic Return

  1. #1
    Registered User
    Join Date
    01-01-2010
    Location
    Orlando, FL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Drop Down Menu with Dynamic Return

    I'm sure Excel is capable of performing the function I require, but for the life of me I can't figure out how to do it. The "IF" formula isn't practical because there are too many prices and variables involved. The VLOOKUP formula seems to be what I need (but I'm not exactly sure) but I've tried and tried and I can't get the return I need.
    In a nutshell, here is what I want to be able to do.

    On Worksheet Sheet1
    I have used the Data Validation method to create a drop down list of 10 Widgets that we sell regularly.
    The drop down list was created using a Name Range of "Widget" - The name range itself is located on Sheet2.


    On Worksheet Sheet2
    I have a list of 10 Widgets that we sell at a fixed price,
    The Text description of these 10 Widgets are listed in Column A A2:A11
    The corresponding selling price for each of these 10 Widgets is listed right next to it in Column B B2:B11


    When I use the drop down menu on Sheet1 to select one of the 10 items, I want the corresponding sale price to automatically appear in the cell to the immediate right of item selected in the drop down list. Obviously the value returned is dynamic based upon the item selected.

    Can anyone explain to me how this is done, what formula to use and how is should be configured?

    Thanks so much.

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

    Re: Drop Down Menu with Dynamic Return

    =Vlookup(a1,Sheet2!$A2:$B11,2,0)

    In which A1 on sheet 1 is the item from the drop down menu.
    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
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Drop Down Menu with Dynamic Return

    You can use vlookup, check out the attachment
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

+ 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. Drop down lists won't return specific data in second drop down menu, just 0.0
    By Torchdesign in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-28-2014, 11:03 AM
  2. [SOLVED] Dynamic drop down menu
    By madhatter40 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-18-2013, 06:33 PM
  3. Dynamic Pie Chart w/ Drop Down Menu
    By JonLombardi in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-17-2013, 01:35 PM
  4. [SOLVED] Dynamic range for drop down menu
    By wyanrandy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-15-2012, 03:16 PM
  5. Dynamic Chart with Drop-Down Menu
    By Katrotat in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-30-2011, 05:30 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