Data Validation List, disallow if not in list

I am using Data Validation on some fields to create a drop down list from a named range! These fields however allow you to enter values that are not in the list.

Is there a way to make the cell have to be an entry from the data validation list?

Hi QCBeauty, welcome to the forum.

Select the cell and click Data -> Validation. On the Error Alert tab, check the box labeled 'Show error alert after invalid data is entered', and then choose 'Stop' from the drop-down list below that. This will prevent any non-valid entries from being entered into that cell.

You could also set the drop-down to warning or information, which may allow the user to enter invalid data with prompting.

If you want to update all of the other data validation cells with the same data validation source/settings, check the box labeled 'Apply these changes to all other cells with the same settings' on the Settings tab of Data Validation before clicking OK.

Hope that helps!

are you sure you are using =namedrange in list option?
see attached validation is in cell a1 named range is martin

Make sure you uncheck the 'Ignore blank' option in the Data Validation settings.