thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
Hi all. I have successfully created a searchable drop down list:
Here is my formula, which is written into a data validation preparation list: =TRANSPOSE(SORT((FILTER(Table1[Name],ISNUMBER(SEARCH(INPUT!K2,Table1[Name])),"not found"))))
I am trying to make 1 modification. I don't want to have to type in the values in order, so currently if I want the below value to be returned,
I can NOT type "Box 2L." If I do this, it will tell me there is no result. Is there a way I can type in any combination of the desired value and have the filter work appropriately?
Many thanks in advance.
Here is my formula, which is written into a data validation preparation list: =TRANSPOSE(SORT((FILTER(Table1[Name],ISNUMBER(SEARCH(INPUT!K2,Table1[Name])),"not found"))))
I am trying to make 1 modification. I don't want to have to type in the values in order, so currently if I want the below value to be returned,
2x2 Box F20T12 2L |
I can NOT type "Box 2L." If I do this, it will tell me there is no result. Is there a way I can type in any combination of the desired value and have the filter work appropriately?
Many thanks in advance.