Dynamically load DataValidation List through Source field?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I'm using the Data, Data Validation, List option to create a dropdown list in
a cell that references a range in my worksheet.

However, the worksheet is very large that populates the dropdown.

Is there a way to filter or dynamically populate the dropdown using a
wildcard such as using a function =VLOOKUP("A*", =$J:$J, 1,False) in the
Source field to populate the dropdown with just the names that start with "A".
 
Sorta. You could setup a range of cells with formulas that only pulled
certain cells, and setup a dynamic range to refer to that cell named MyRange.
Then, in Data Validation, have it reference MyRange.
 
Back
Top