Data Validation: Cell reference to Named Range

**niceguy21** · 11-07-2012, 08:30 AM

If I have two cells and a named range mexico

A1, A2.

A1 contains the string: "mexico"
A2 is the cells that has required data validation (drop down list).

I want A2's validation reference to be dynamic, in the sense that I can it reference it to A1; converting the string "mexico" to a named range mexico

I tried inputing = INDIRECT(A1) into A2

But I lack clarity in my understanding of referencing.

What is the correct procedure here?

Thanks.

**TMS** · 11-07-2012, 09:02 AM

For Data Validation, you wouldn't put that formula into cell A2. You'd set the cell up to use Data| Data Validation and in the Allowed box put =INDIRECT(A1).

I suggest that you post a sample workbook to test the theory.

Regards, TMS

**niceguy21** · 11-07-2012, 10:41 AM

Originally Posted by TMShucks

For Data Validation, you wouldn't put that formula into cell A2. You'd set the cell up to use Data| Data Validation and in the Allowed box put =INDIRECT(A1).

I suggest that you post a sample workbook to test the theory.

Regards, TMS

Sorry, I meant that I entered =INDIRECT(A1) into the data validation box for A1. Still not working.

Named Range: mexico

find similar test file below.

https://dl.dropbox.com/u/69651453/test22.xlsx