I'm an Excel novice, so forgive a probably basic question.

I set up a spreadsheet where a set of cells does Validation against a list.
I did this by doing the following:

1) On Worksheet 1, I made a list of values (e.g. Red, Blue, Green).
2) I then selected that list and gave it a Name.
3) On Worksheet 2, I selected a set of cells, and choose to Validate those
cells against the Named list.

So that's great. In Worksheet 2, each cell now has a dropdown arrow where I
can choose a List value from Worksheet 1.

But what I want is to start typing into a cell in Worksheet 2 and have the
value auto-fill from the Worksheet 1 list. For example, if I type "r", I
want "Red" to auto-fill in that cell.

Can I do this? If not, MSFT, this is a feature request.

Thanks.

Dave