HELP, Autocomplete search word based on Initial first/random word

[radian89]

Hi All,

I've been looking anywhere but I couldn't find the solution, please help. My problem is i want to do autocomplete search based on these condition

1. initial first or random word that contained in the list data.
2. the search result will be auto sorted from A to Z, not case sensitive, where the first will be the showed result search.

what i hope is in the attachment or you can see picture below. what'll be the formula?

so if i type "ij" the result should be Indonesia Jakarta (while 2nd result is Indonesia Jambi)
if i type "ny" the result should be New York
if i type "ind" the result should be India New Delhi (because, if it's sorted India New Delhi will be the first to come out)

[/IMG]

thanks a lot for the help ^^
warm regards

 

[oldbrewer]

if you put all your data in a lookup table

then typing the acronym will return

all the possible matches

the first column does not have to be

in alphabetical order

1

2

3

4

ij

indonesia jakarta

indonesia jamb1

ny

new york

ind

india new delhi

india mumbai

indonesia jakarta

indonesia jamb1

indonesia surabaya

1

2

3

4

5

6

ind

india new delhi

india mumbai

indonesia jakarta

indonesia jamb1

indonesia surabaya

0

formula giving india new delhi

=OFFSET($J$9,MATCH($E18,$J$10:$J$12,0),F17)

<colgroup><col><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>