Welcome,
Is it possible to set (in one selected case) AutoComplete based on the indicated location?
by default, autocomplete works on the data from the previous lines:
... by entering data into the spreadsheet, in the case of entering a new chord in the next line, the program checks whether there is a repetition in the same column (previous lines) and based on the entered characters, AutoComplete appears, which I can tap with Enter,
I am looking for a method and I want the AutoComplete to be based on the data I give (the table I am indicating) then the program will read them from the indicated location, not from the lines above.
example:
In Sheet2 in cell A2 I write the letter "A", then I want the hint (Adam) to be highlighted based on the list of names I have provided in the table from Sheet1 A2: A7.
greetings
Is it possible to set (in one selected case) AutoComplete based on the indicated location?
by default, autocomplete works on the data from the previous lines:
... by entering data into the spreadsheet, in the case of entering a new chord in the next line, the program checks whether there is a repetition in the same column (previous lines) and based on the entered characters, AutoComplete appears, which I can tap with Enter,
I am looking for a method and I want the AutoComplete to be based on the data I give (the table I am indicating) then the program will read them from the indicated location, not from the lines above.
example:
In Sheet2 in cell A2 I write the letter "A", then I want the hint (Adam) to be highlighted based on the list of names I have provided in the table from Sheet1 A2: A7.
greetings
