Cyberdude
12-11-2006, 04:36 AM
?XYZ16? is the defined name of a formula which looks like:
='C:\EXCEL Documents\Weekly Totals Rpt.xls'!ABC16
where ?ABC16? is a defined name for a formula in a different workbook. That formula looks like:
=Shares!$BQ$16
To get the value of the formula ?XYZ16? I write:
=XYZ16
This works just fine.
Actually ?XYZ16? is one of a family of formulas with a defined name for each. So I have a group of formulas with defined names like ?XYZ2?, ?XYZ10?, ?XYZ16?, and so on.
What I want to do is change the reference so that the ?16? is a variable value. Instead of writing:
=XYZ16
I?d like to write something like:
=INDIRECT(?XYZ? & 2 * ROW())
but I can?t seem to find the correct combination. Is this something that can?t be done?
='C:\EXCEL Documents\Weekly Totals Rpt.xls'!ABC16
where ?ABC16? is a defined name for a formula in a different workbook. That formula looks like:
=Shares!$BQ$16
To get the value of the formula ?XYZ16? I write:
=XYZ16
This works just fine.
Actually ?XYZ16? is one of a family of formulas with a defined name for each. So I have a group of formulas with defined names like ?XYZ2?, ?XYZ10?, ?XYZ16?, and so on.
What I want to do is change the reference so that the ?16? is a variable value. Instead of writing:
=XYZ16
I?d like to write something like:
=INDIRECT(?XYZ? & 2 * ROW())
but I can?t seem to find the correct combination. Is this something that can?t be done?