Dynamically load DataValidation List through Source field?

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave" wrote:

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