Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi column Data Validation List
I am using DATA = Validation = List to control input
into a single column range. The data being entered is only job numbers and as a number, does not offer the user enough information. Is it possible to have the List that appears show 2 columns of information that could include the Job Name. When I try to refer the validation list to a 2 column range, I get the following message: "The List Source must be a delimited list or a reference to a single row or column" Is there a work around for this? I've read more books on this than I can count. Thanks in advance. Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi column Data Validation List
Could you combine the two columns into another and use that column:
=a1& "--" & b1 Or just show the description column and use a vlookup (index/match) to return the job number to an adjacent cell. Chris wrote: I am using DATA = Validation = List to control input into a single column range. The data being entered is only job numbers and as a number, does not offer the user enough information. Is it possible to have the List that appears show 2 columns of information that could include the Job Name. When I try to refer the validation list to a 2 column range, I get the following message: "The List Source must be a delimited list or a reference to a single row or column" Is there a work around for this? I've read more books on this than I can count. Thanks in advance. Chris -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Table Column for Data Validation List | Excel Discussion (Misc queries) | |||
Data Validation Drop down list to Autofill next column | Excel Worksheet Functions | |||
How to find a value with multi-column, multi-record list | Excel Worksheet Functions | |||
Multi-level dependent data validation | Excel Discussion (Misc queries) | |||
How to copy data validation utilizing a list to the entire column | Excel Worksheet Functions |