With the List option in the group of data-validation settings,you can generate an error message if a value that is not includedin a list is entered in the cell range you’re validating.Supposeyou’re entering employee first names in the cell range A1;A10. Theonly employees of the company are Jen, Greg, Vivian, Jon, ad John.Use the List option to ensure that no one misspells a firstname.
USE EXCEL
Expert Answer
An answer will be send to you shortly. . . . .