First off my data is simple- five columns Manufacturer, Type, Description, Function, Category
I need to create a user form that allows the user to select Manufacturer and Function from a drop down list.
Once they choose manufacturer and function, I need the vlookup to provide all of the valid types, descriptions and categories associated with the selected manufacturer and function.
Can someone point me in the right direction. For example in a worksheet I know how to create a drop down list associated with a range. I do not know how to do the vlookup.
The goal here is to pick a type based on the manufacturer and function. My solution has to provide in a form a way for me to pick the type based on the manufacturer and function.
Thank you for the help.
I need to create a user form that allows the user to select Manufacturer and Function from a drop down list.
Once they choose manufacturer and function, I need the vlookup to provide all of the valid types, descriptions and categories associated with the selected manufacturer and function.
| Manufacturer | Type | Description | Function | Category |
| A10 Networks | IDS100 | Firewall | Appliance | HUB |
| A10 Networks | AX-1030 | AAD Controller | Controller | hub |
| Alpermann&Velte | RUB-H3 | gateway | Chassis | hub |
Can someone point me in the right direction. For example in a worksheet I know how to create a drop down list associated with a range. I do not know how to do the vlookup.
The goal here is to pick a type based on the manufacturer and function. My solution has to provide in a form a way for me to pick the type based on the manufacturer and function.
Thank you for the help.
