Validate Data Based on a List on Another Worksheet
This tutorial provides two methods you can use to validate data based on a list on another worksheet.
The first method takes advantage of Excel's named ranges, and the second uses a function call.
Following these sections:
- Method 1: Named Ranges (Perhaps the easiest and quickest way to overcome Excel's data-validation barrier is by naming the range where the list resides.)
- Method 2: the INDIRECT Function (The INDIRECT function enables you to reference a cell containing text that represents a cell address.)
