Hi,

Let's say you have one sheet with a list of products.
Column1 = product name
Column2 = product number

I would like to have a cell on Sheet2, where I can start typing something,
and it would let me see a list based on what I typed so far.
E.g when I type "Volks" it should show a list of all Volkswagen Cars.

If I then choose the value, it should use this value and add the product
number in the cell next to it.

What function should I use, or how can I do this?

Thanks,

Roel