Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you validate a list with more than one column
hi, how can one create a list with multiple rows so when you select a row it
posts all the entries in list (maybe 5 rows of corresponding data to that list header). It brings up an error saying that you can use only one row or delimited text. An example being selecting a person ie the main item in the list and then all the columns of data responding to that person size, eye colour, favourite food etc coming up automatically in the adjacent cells... Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you validate a list with more than one column
You can have only one column in a DV dropdown list.
To pull the rest of the data you can use VLOOKUP formulas. Visit Debra Dalgleish's site for info on Data Validation selection lists. http://www.contextures.on.ca/xlDataVal01.html Also see Debra's info on VLOOKUP function to pull data based on the selection from the DV list. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Tue, 19 Feb 2008 17:08:00 -0800, millionmiler wrote: hi, how can one create a list with multiple rows so when you select a row it posts all the entries in list (maybe 5 rows of corresponding data to that list header). It brings up an error saying that you can use only one row or delimited text. An example being selecting a person ie the main item in the list and then all the columns of data responding to that person size, eye colour, favourite food etc coming up automatically in the adjacent cells... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validate duplicate entry in a column | Excel Discussion (Misc queries) | |||
How to validate list data from a different workbook | Excel Discussion (Misc queries) | |||
converted a column to List yet wants to Validate as well | Excel Discussion (Misc queries) | |||
How to validate data in already list dropdown validated. | Excel Discussion (Misc queries) | |||
validate data from list without picklist | Excel Discussion (Misc queries) |