I have created the following forumla to help make a drop-down list serachable: =OFFSET(F7,,,COUNTIF($F$2:$F$52,”?*”))
I think named this formula, in the name Manager as ‘Validation’
Normaly I would just add this into the data validation bar to allow users to search the drop-down. However, the drop-down that this relates to is dynamic (contains 4 drop downs initially) and then uses =Indirect(B36) as the forumla within the data validation.
How can i combine the two formulas so that if a particular drop down is selected (from the 4 listed) that this then becomes serachabale. I dont need the search to apply to the other drop-downs as they are very short lists.