Data Validation Formulas

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.


Thank you,




Leave a Reply

Your email address will not be published. Required fields are marked *