Check out VLOOKUP function.

Better yet.................

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

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

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

Note the section on using DV lists from another worksheet by naming the list.


Gord Dibben MS Excel MVP


On Thu, 10 May 2007 21:43:06 -0700, oldLearner57
wrote:

hi community

i wanted to create a "Pick List" that reference data from another worksheet
in the same workbook
example:

sheet 1

A B C D

1 Budget Condo 4 rms $200000

2 Spender Penthouse 6 rms $400000

Sheet 2

In sheet2, I wanted to create a Pick List that when select, eg, "Budget", it
will display out the information that is pointing to Sheet 1!A1:D1

is there ways to do?

I able to do a simple Pick List using the vlookup() but only return a single
column in the same worksheet , however, now I want the return to be more than
1 column and data is from another worksheet??

any help much appreciated :)

thanks community for assistance :)