Dynamically load DataValidation List through Source field?

[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".

 

[Luke M]

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.