Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dependant parts list -lookup
Hello trying to find a way to have a row of dependant columns ,where the
first row has a drop down menu with a list of parts like a lamp body, then the next cell over shows a list which would change depending on the first selection. until a whole part # is created from all the indiviual pieces. That then would return in a different cell a quantity of available for sale and a price specific to that unique part #. I already have a sheet that has the quantities and pricing. |
#2
|
|||
|
|||
Having one Data Validation cell display a list that is dependent on the
selection made in another Data Validation cell can be done without VBA. However, you can do this for only one list that is dependent on the selection in another list. From what you say, I gather that you want to have more than one list dependent on another. You want a chain of them. Is that correct? If so, you will need VBA. Post back and clarify the number of dependencies you need. HTH Otto "BEEZ" wrote in message ... Hello trying to find a way to have a row of dependant columns ,where the first row has a drop down menu with a list of parts like a lamp body, then the next cell over shows a list which would change depending on the first selection. until a whole part # is created from all the indiviual pieces. That then would return in a different cell a quantity of available for sale and a price specific to that unique part #. I already have a sheet that has the quantities and pricing. |
#3
|
|||
|
|||
Correct I would like to be able to do at least 4 or more
Example: Fixture Type Wattage Type of reflector Color QTY Price Outdoor wall 150 W Aluminum Bronze 32 $ 100.00 Then kind of like a V-lookup function on the sum of the parts "Outdoor wall 150W Aluminum Bronze " vlookup = 32 vlookup=$100.00 "Otto Moehrbach" wrote: Having one Data Validation cell display a list that is dependent on the selection made in another Data Validation cell can be done without VBA. However, you can do this for only one list that is dependent on the selection in another list. From what you say, I gather that you want to have more than one list dependent on another. You want a chain of them. Is that correct? If so, you will need VBA. Post back and clarify the number of dependencies you need. HTH Otto "BEEZ" wrote in message ... Hello trying to find a way to have a row of dependant columns ,where the first row has a drop down menu with a list of parts like a lamp body, then the next cell over shows a list which would change depending on the first selection. until a whole part # is created from all the indiviual pieces. That then would return in a different cell a quantity of available for sale and a price specific to that unique part #. I already have a sheet that has the quantities and pricing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
Lookup List to Index | Excel Worksheet Functions | |||
Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Lookup closest number in list | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |