With the List option in the group of data-validation settings, you can generate an error message if a value that is not included in a list is entered in the cell range you're validating.Suppose you're entering employee first names in the cell range A1;A10. The only employees of the company are Jen, Greg, Vivian, Jon, ad John. Use the List option to ensure that no one misspells a first name.

USE EXCEL