Forum Discussion
Auto-populate contacts list with multiple choices
It's difficult to combine a formula and a variable drop-down list; it would require VBA code.
Here is a solution with a data validation drop-down in column C and formulas in column D (spilling to E and F)
Thank you for your solution. I was hoping to avoid multiple dependent drop down lists, but it seems that may be best way to solve this.
I did forget to mention that there is a possibility that a company may have multiple contacts. For example, the same flooring company could have a project lead and the principal. Because of this possibility, I am assuming that I will require 3 drop down lists (category, company name, and contact name).
With this situation in mind, it's a lot of drop down lists to choose from. Although, it is better than typing it out each time or copy/paste, as that leaves more room for error. I am just trying to make it as easy as possible for out team, and am not entirely convinced that selecting from 3 drop down lists to get the full information per contact is the right way to go.
Any suggestions for alternative solutions?
