Hi. I have list of products with its relevant data on sheet2. I would
like to have an autocomplete function on sheet1 based on product name
(column B, sheet2)?!

Since many products does have first word in name the same, how to
enable autocomplete from start of typing (normaly autocomplete shows a
proposal when there is a single solution).

Best regards,

If I understand the question correctly, when you begin typing the
autocomplete will offer what it thinks you are about to type. If the data
offered by autocomplete is not what you want, continue to type and
autocomplete will then offer new data based on what you typed. You can
continue this process until it finds the data you want. I am not sure if
the offerings are in alpha/numeric order or if they are in the order of
original entry, but the offerings are based on a character by character
comparison of what the user types in.



"TiMe25" wrote in message
...
Hi. I have list of products with its relevant data on sheet2. I would
like to have an autocomplete function on sheet1 based on product name
(column B, sheet2)?!

Since many products does have first word in name the same, how to
enable autocomplete from start of typing (normaly autocomplete shows a
proposal when there is a single solution).

Best regards,