Depending on what spreadsheet program you're using, the process of adding data validation will vary. Since users won't have to type in data manually, the spreadsheet will be faster to use, and there's a much lower chance that someone can introduce an error. This kind of data validation allows you to build a powerful, fool-proof spreadsheet. To make things even easier, we can insert a drop-down list of the possible options. In our example, we can use data validation to ensure that the user chooses one of the three possible shipping options. Data validationĭata validation allows you to control exactly what a user can enter into a cell. To make sure this doesn't happen again, we can add data validation to our spreadsheet. While we could simply type in the correct spelling, that wouldn't prevent someone from making the same mistake in the future. The Shipping worksheet doesn't contain the word ' Standrd', so our VLOOKUP function doesn't return any results. If we look at cell E6, we can see that the word Standard is misspelled.

Vlookup with dropdown mac excel 2013