Hi

I have a number of cells that I would like to 'look up' a series of data from a separate column. I have managed to do this using the data validation (using the 'list' option under allow and then specifying the data range.

I would however, like to use the 'type ahead' feature in entering this information rather than simply choosing from a list of values. For example - the option "Porsche" will be one of the items in my list, I would like to start typing"Po....." and the cell to recognise that I am going to type "Porsche" - is this functionality possible in Excel ?

Many thanks