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 :)


--
oldLearner57