You need a lookup table and the use of VLOOKUP function in cells adjacent to the
DV dropdown list.

See Debra's site for help on VLOOKUP

http://www.contextures.on.ca/xlFunctions02.html


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 15:36:01 -0700, Bagpuss
wrote:

Tom

Dynamic list works fine, but still unclear how to select multiple columns of
data from a drop down list eg with names and addresses, if select name with
data validation can I also populate cells with relevant address details?
Using Office 2003

"Tom Ogilvy" wrote:


http://www.contextures.com/xlDataVal01.html
the basics

http://www.contextures.com/xlDataVal05.html
to get a list from another workbook or another worksheet


http://www.contextures.com/xlFunctions02.html
How to pull in related data based on a key data element value

--
Regards,
Tom Ogilvy



"Bagpuss" wrote:

How can I use a combobox to select 1 row with 5 colums data from a seperate
worksheet containing over 100 rows of data and populate 5 cells on current
sheet? Ideally would like to detect number of rows of data automatically to
cope with different lists