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,