![]() ![]() If you do NOT want that feature you can tweak the FILTER condition to use something like LEFT(A:A,LEN(C1))=C1ī) because you must let the user enter a character or 2 you can't force the input to ONLY be in the list. ![]() your 'do' example would also show "Andover" and "Zanador". Also, using SEARCH will filter the list with matches anywhere in the word i.e. Without that function it gets more complicated. ![]() This example and the link are relying on the new FILTER() function. So actual list in col A then in col B you have something like Filter(A:A, isnumber(search(C1, A:A))) and then the drop down in cell C1 is based on col B. Here is one: Ī) basically all you are doing is referring to a list that is basically a 'helper' list (a helper column that creates a filtered version of the original list) that is filtered based on the value in the cell you are entering. As you can google search and many options will come up. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |