software

I have a workbook with a variety of names ranges. I need the data to flow
into corresponding cells based on the result of a formula in a different
cell. Example:

A1 contains a validation drop-down of all the named ranges in the workbook.

Range A212 results in the selection of the drop-down in A1. These named
ranges are from different workbooks. I've tried lookup functions, but they
will not accept a cell reference in place of a hard-coded name to lookup the
correct range of data.

I need the cell reference to insert into a formula as a named range.
A1=NamedRange

I end up getting the value in A1 returns in the formula as only the only
data. The value is not recognized as a named range.

I hope this makes sense.

Hi!

Try this:

INDIRECT(A1)

gt;These named ranges are from different workbooks

If that's the case, using Indirect requires that those files be open.

Also, if some named ranges are really named formulas like those used to
create dynamic ranges, Indirect will not work.

Biff

quot;ExcelRookiequot; gt; wrote in message
news
gt;I have a workbook with a variety of names ranges. I need the data to flow
gt; into corresponding cells based on the result of a formula in a different
gt; cell. Example:
gt;
gt; A1 contains a validation drop-down of all the named ranges in the
gt; workbook.
gt;
gt; Range A212 results in the selection of the drop-down in A1. These named
gt; ranges are from different workbooks. I've tried lookup functions, but they
gt; will not accept a cell reference in place of a hard-coded name to lookup
gt; the
gt; correct range of data.
gt;
gt; I need the cell reference to insert into a formula as a named range.
gt; A1=NamedRange
gt;
gt; I end up getting the value in A1 returns in the formula as only the only
gt; data. The value is not recognized as a named range.
gt;
gt; I hope this makes sense.
Named ranges are good only within a workbook. If you are calling in
RangeNames from other workbooks, you'll need to associate it with a path and
filename.

hth
Vaya con Dios,
Chuck, CABGx3
quot;ExcelRookiequot; wrote:

gt; I have a workbook with a variety of names ranges. I need the data to flow
gt; into corresponding cells based on the result of a formula in a different
gt; cell. Example:
gt;
gt; A1 contains a validation drop-down of all the named ranges in the workbook.
gt;
gt; Range A212 results in the selection of the drop-down in A1. These named
gt; ranges are from different workbooks. I've tried lookup functions, but they
gt; will not accept a cell reference in place of a hard-coded name to lookup the
gt; correct range of data.
gt;
gt; I need the cell reference to insert into a formula as a named range.
gt; A1=NamedRange
gt;
gt; I end up getting the value in A1 returns in the formula as only the only
gt; data. The value is not recognized as a named range.
gt;
gt; I hope this makes sense.