G
Guest
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!A11
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
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!A11
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