Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Now that your two-way lookup is complete, you could go one step further by adding a drop-down list to the cells containing the lookup values to speed up the data retrieval process.

If your list and dropdown are on different pages, you’ll need to know this trick to make the dropdown dynamic.