A drop-down box and dependent values

  • Thread starter Thread starter Debra
  • Start date Start date
D

Debra

I have a listbox with Vendors. Once a Vendor is picked, I
would like to have the Contact Name and email
automatically populated:

Vendor Name:
Contact Name:
Contact Email:

I was thinking of building a table in Excel and using the
Microsoft Query but I don't know much about it.
Thank you!
 
Tom.
This is an excellent idea. Thanks.
-----Original Message-----
build the table and use the worksheet function Vlookup.

--
Regards,
Tom Ogilvy




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top