Home / MS-Excel / General Formatting

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.)

In this tutorial:

  1. Method 1: Named Ranges
  2. Method 2: the INDIRECT Function