using a name label within an index function

  • Thread starter Thread starter Floran Stuyt
  • Start date Start date
F

Floran Stuyt

I have defined a name label which contains a path to an external lookup
workbook.

If I put the path in each formula in each cell the formula looks like
this: INDEX('c:\directory to workbook\workbook.xls'!MYDEFINEDRANGE;10, 12)

I want to use it like this:
INDEX(NameLabelThatContainsThePathToWorkbook!MYDEFINEDRANGE;10, 12)

But this doesn't work. I'm using Excel 2002. Please help me.

Thank you...
 
Hi
not possible with Excel's build in functions. Have a look at:
http://tinyurl.com/2c62u

--
Regards
Frank Kabel
Frankfurt, Germany

Floran Stuyt said:
I have defined a name label which contains a path to an external lookup
workbook.

If I put the path in each formula in each cell the formula looks like
this: INDEX('c:\directory to
Click to expand...
workbook\workbook.xls'!MYDEFINEDRANGE;10, 12)
 
Back
Top