+ Reply to Thread
Results 1 to 7 of 7

Can VLOOKUP Result in a DROP DOWN of Results

  1. #1
    Registered User
    Join Date
    05-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Cool Can VLOOKUP Result in a DROP DOWN of Results

    Hey Guys,

    Do you know if Excel 2010 is capable of running a VLOOKUP that will result in a drop down list? If not, do you know anyway to do this?
    Any help with be awesome!!

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Can VLOOKUP Result in a DROP DOWN of Results

    What kind of drop down list... data validation?

  3. #3
    Registered User
    Join Date
    05-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Can VLOOKUP Result in a DROP DOWN of Results

    Yes exactly, a data validation drop down list

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Can VLOOKUP Result in a DROP DOWN of Results

    Well you can specify a range of cells or a named range as the list in data validation settings. Just do your vlookup in those cells. If you want the list to be dynamic (grow and collapse in correlation to the desired range), there's already plenty of info on the web on how to do that.

  5. #5
    Registered User
    Join Date
    05-23-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Can VLOOKUP Result in a DROP DOWN of Results

    Hey Jhren,

    Thank you for the quick reply, here is a basic synopsis of what I am trying to do. I am creating a product pricing spreadsheet for my work, and have already got down the whole depdenet list. Below are the categories in my list.

    Vendor ProductType BrandName ProductSize Color Specs Price

    I was successful in my task to map everything to each other except for the the Color and Specs. Both of these categories need to use the INDIRECT function (or so I think) on the BrandName category to pull the appopriate information. The problem arises because I already have mapped the ProductSize to BrandName, therefore am not sure at all how to proceed. I have attached the workbook to this message as well. The worksheet I am working on is called Master Calculation sheet and I basically want to be able to take the information in the cell in BrandName and pull data from my ColorAndOtherSpecifications Worksheet to the cell in Color Selection.

    Any advise would be awesome, and thanks again for your help!Price Calcuation V2.xlsx

    Sajan

  6. #6
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Can VLOOKUP Result in a DROP DOWN of Results


  7. #7
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Can VLOOKUP Result in a DROP DOWN of Results

    Continue on as you have been doing in columns A to D. As you can see, as you progress across the worksheet, the need for lists increases dramatically.

    Right now, you don't have any data on the Color and Other Specs tab that can tie the colors to the very specific products that you have specified in columns A to D.

    It appears that you will probably need a color list for every item that is listed on the Pricing tab.

    For example of what you are going to have to sort out: There are nearly 30 Soft Touch Hard Covers of various types. Do these have a common color scheme? If they do, then you can cut down on the number of lists for color that you have to create. Even doing this, you are going to have a huge number of color lists for your products.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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