Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a pick list from more than one column
Hi All I hope I can get some help with this, if it is even possible. I want to set up a pick list. The data validation allow list function appears to be the closest to what I want. I understand how to use this and if a solution isnt readily apparent I will be satisfied with my current situation. Problem 1: What I would like to do is have two lists in column. The first list would have letter/number combinations. The second column would have a description. I would like to select the letter/number combination and have the description automatically fill. Is that even possible? Is there another function or method that could do this? Problem 2: If the above is possible, could a third column be added between the two for a quantity input field? For problem 1, I have considered merging the two fields but would prefer, if possible, to use a list that triggers the two. I have also considered two separate lists but the chance of error is very real. Thanks for any input or suggestions. My level of expertise is competent user. I am not a programmer. Joe |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a pick list from more than one column
You can use a VLLOKUP formula in the second column. That way, you pick the
number from the list, and the description gets filled by the VLOOKUP. Say you have your list, consisting of the number in the first column, and the description in the second one. Let's say you called this nList. In B1, if your DV is in A1, enter =IF(A1="","",VLOOKUP(A1,dList,2,0)) You can of course insert a quantity column anywhere you wish. -- HTH Kassie Replace xxx with hotmail "subroc" wrote: Hi All I hope I can get some help with this, if it is even possible. I want to set up a pick list. The data validation allow list function appears to be the closest to what I want. I understand how to use this and if a solution isnt readily apparent I will be satisfied with my current situation. Problem 1: What I would like to do is have two lists in column. The first list would have letter/number combinations. The second column would have a description. I would like to select the letter/number combination and have the description automatically fill. Is that even possible? Is there another function or method that could do this? Problem 2: If the above is possible, could a third column be added between the two for a quantity input field? For problem 1, I have considered merging the two fields but would prefer, if possible, to use a list that triggers the two. I have also considered two separate lists but the chance of error is very real. Thanks for any input or suggestions. My level of expertise is competent user. I am not a programmer. Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dropdown list within a column | Excel Discussion (Misc queries) | |||
Creating a new list of repeating data in a column | Excel Worksheet Functions | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
creating a list from a column of semicolon | Excel Discussion (Misc queries) |