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!!
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!!
What kind of drop down list... data validation?
Yes exactly, a data validation drop down list
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.
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
See if this tutorial helps...
http://excelsemipro.com/2011/05/a-dy...list-in-excel/
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks