how do you validate a list with more than one column

[millionmiler]

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

 

[Gord Dibben]

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