Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Multiple Dependent Drop Down | Excel Worksheet Functions | |||
Dependent drop-down boxes | Excel Worksheet Functions | |||
dependent drop down - repeat values | Excel Worksheet Functions | |||
Drop Down Value & Length Dependent | Excel Worksheet Functions |