A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can ...