Hi to all
I've created a table to calculate distance between 2 regions.
There are 4 lists created with data validation, 2 of them use country names, defined with "trav" name, other 2 are regions which will show for corresponding country with indirect function. After selection, vlookup formula will check in which zones are selected regions. Finally, index/match will look how far are zones from eachother.
Hope you understand that, what I wish for now is to all 4 lists be autocomplete ones.
When user start to type first few letters of a country, first match would appear as result (CRO=Croatia)*. Same would work for region selection. User would type first few letters and region would come up**.
*If its possible to filter choices as user type.
Ex. "C" will bring Chile, China, Croatia
"Ch" Chile;China
"Chin" autocomplete China
**All mine previous formulas have to work after this new changes
Hope you understand
Thanks
I've created a table to calculate distance between 2 regions.
There are 4 lists created with data validation, 2 of them use country names, defined with "trav" name, other 2 are regions which will show for corresponding country with indirect function. After selection, vlookup formula will check in which zones are selected regions. Finally, index/match will look how far are zones from eachother.
Hope you understand that, what I wish for now is to all 4 lists be autocomplete ones.
When user start to type first few letters of a country, first match would appear as result (CRO=Croatia)*. Same would work for region selection. User would type first few letters and region would come up**.
*If its possible to filter choices as user type.
Ex. "C" will bring Chile, China, Croatia
"Ch" Chile;China
"Chin" autocomplete China
**All mine previous formulas have to work after this new changes
Hope you understand
Thanks
