Autocomplete (and autolookup) as I type plus copy data

Originally Posted by TonyB51

Hi,

I sounds like you need a List Box, found under Data Validation.

refer to the attached example.

I think it will work for you.

Cheers

TonyB

Hey Tony,

Thanks heaps for your help. I had totally forgot to give Data Validation a try (I had done it with some other things in the spreadsheet).

However, one slight issue - it won't autocomplete as you type. It requires you to either select the child's name from the drop-down list, or you need to type the full name exactly. Hope this makes sense.

Actually, another option if I go the Data Validation path is, is it possible to build the list of names, for the validation list, IF the value in the E column is equal to "Creche" for example?