A drop-down box and dependent values
 

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!

A drop-down box and dependent values
 

build the table and use the worksheet function Vlookup.

--
Regards,
Tom Ogilvy

"Debra" wrote in message
...
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!

A drop-down box and dependent values
 

Tom.
This is an excellent idea. Thanks.
-----Original Message-----
build the table and use the worksheet function Vlookup.

--
Regards,
Tom Ogilvy

"Debra" wrote in message
...
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!


.