using a name label within an index function

[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...

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

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)