| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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". |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Offset Named range in Datavalidation List | Excel Discussion (Misc queries) | |||
| ComboxBox with Dynamically Defined Source, and LinkedCell error | Excel Discussion (Misc queries) | |||
| Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
| datavalidation conditional list | Excel Discussion (Misc queries) | |||
| datavalidation conditional list | Excel Discussion (Misc queries) | |||
Threaded Mode
