You can use VLookup formulas to display the related data. There's an
example in an order form he
http://www.contextures.com/xlOrderForm01.html
And instructions for VLookup formulas he
http://www.contextures.com/xlFunctions02.html
neostar77 wrote:
Hi,
I want to create a Drop Down menu in Excel.
After I create the Drop Down menu, and when I select a name from the drop
down menu, the name selected should populate or display the address
information of that name in the other columns i.e. 1 column for city, 1
country, 1 for postal code/zip, etc.
How do I go about doing that?
--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog:
http://blog.contextures.com