As a reminder, here's how to set up data validation to use a dropdown:

1. Enter the choices for the dropdown in a certain spot
2. Define a named range that includes the choices from step 1
3. On the Excel menu click Data Validation
4. In the Allow box, choose List
5. In the Source box, enter the formula =YourNamedRange and click OK
where YourNamedRange is the named range you created in step 2

The List in step 4 is probably the "list" your post references.

Good luck with it!
Dave O
Eschew Obfuscation