E
ExcelRookie
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.
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.