Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list showing different value
What I am trying to do is create a drop down list where the department is
shown in the list (Art, Style, Photography) but once the name is selected, the department number shows up. For example, if someone chose Art, I want the department number to show up in the cell (1000). Art 1000 Style 1001 Photo 1002 Please help! Thanks so much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list showing different value
If you are using a data validation list you can just use a vlookup
Vlookup(A1,CreateYourLookupArray,2,FALSE) If it is a combo box drop down, then you have to use the cell link mixed with offset and vlookup formulas. "dspitler" wrote: What I am trying to do is create a drop down list where the department is shown in the list (Art, Style, Photography) but once the name is selected, the department number shows up. For example, if someone chose Art, I want the department number to show up in the cell (1000). Art 1000 Style 1001 Photo 1002 Please help! Thanks so much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list showing different value
You can use programming to do this. There's a sample file here that
fills in a product code, after a product is selected. You could adapt the technique to your workbook: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0004 - Data Validation Change' dspitler wrote: What I am trying to do is create a drop down list where the department is shown in the list (Art, Style, Photography) but once the name is selected, the department number shows up. For example, if someone chose Art, I want the department number to show up in the cell (1000). Art 1000 Style 1001 Photo 1002 Please help! Thanks so much. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list showing different value
This is exactly what I need, but the .zip file doesn't really explain how to
create this kind of data validation. I need two different validation change tables, so I tried just copying and pasting cells B2:B16 to another area in the sheet. The drop-down lists copied over, but not the data change. I'm very new at writing code, and couldn't figure out how to change the code to fit my needs. Can someone explain how the data validation change in the .zip file was created in the first place? "Debra Dalgleish" wrote: You can use programming to do this. There's a sample file here that fills in a product code, after a product is selected. You could adapt the technique to your workbook: http://www.contextures.com/excelfiles.html Under Data Validation, look for 'DV0004 - Data Validation Change' dspitler wrote: What I am trying to do is create a drop down list where the department is shown in the list (Art, Style, Photography) but once the name is selected, the department number shows up. For example, if someone chose Art, I want the department number to show up in the cell (1000). Art 1000 Style 1001 Photo 1002 Please help! Thanks so much. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list not showing all the data.... | Excel Discussion (Misc queries) | |||
drop down list showing dates instead of numbers | Excel Discussion (Misc queries) | |||
drop down list is not showing | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Drop Down Tab not showing-Tried Everything | Excel Discussion (Misc queries) |