- Jun 9, 2008
I tried using the solutions posted in earlier threads to no avail. I have two drop downs and need to limit the resusts of the second based on the value displayed in the first. Example: 15 Depts, each dept has between 12 and 20 agents. When I choose dept a, I only want those agents in that department to display in the list for the second drop down. I have named ranges, tried INDIRECT and INDIRECT with VLOOKUP. Any other thoughts???