A drop-down box and dependent values

[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 Ogilvy]

build the table and use the worksheet function Vlookup.

 

[Debra]

Tom.
This is an excellent idea. Thanks.

-----Original Message-----
build the table and use the worksheet function Vlookup.

--
Regards,
Tom Ogilvy




.