Named external cell reference

  • Thread starter Thread starter Michael Rouse
  • Start date Start date
M

Michael Rouse

Hi there.
I have a workbook "ingredients" with a named column
("unitcost") and named rows (eg "flour", "sugar"). Within
that workbook I can use names of intersecting cells fine
(eg "unitcost sugar"). However I can't seem to use those
intersecting references from another workbook, for example:
"ingredients.xls!unitcost sugar". Is this possible, or
will I have to use VLOOKUP?
Hope someone can help.
 
Michael Rouse said:
Hi there.
I have a workbook "ingredients" with a named column
("unitcost") and named rows (eg "flour", "sugar"). Within
that workbook I can use names of intersecting cells fine
(eg "unitcost sugar"). However I can't seem to use those
intersecting references from another workbook, for example:
"ingredients.xls!unitcost sugar". Is this possible, or
will I have to use VLOOKUP?
Hope someone can help.
Click to expand...

You need to include the workbook name in each range name reference:
ingredients.xls!unitcost ingredients.xls!sugar
 
Back
Top