Prev: Conditional formatting Icons
Next: Tab Control
From: Dave on 12 Feb 2010 14:35
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".

From: Luke M on 12 Feb 2010 15:35
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".
>
 | 
Pages: 1
Prev: Conditional formatting Icons
Next: Tab Control