Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use Excel tools to validate a U.S. state.