Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
One if statement, using data from two or more lists.
Instead of having multiple drop down boxes, how can I have one or two drop down boxes and then have the other cells populate based on the selection from said drop down box.
Example: Two lists, one with names and the other with email addresses. When a user selects a name then an email address will be displayed in the assigned cell.
Any help would be much appreciated. Non-VBA first as I am very poor at VBA, so if, lookup, match statements would be awesome. The lists are words (strings) and that is what is throwing off my returns in if, lookup, and match statements.
Hopefully this all makes sense. Thank any and everyone for your time and consideration.