lookup limits

  • Thread starter Thread starter Don Pistulka
  • Start date Start date
D

Don Pistulka

Hi,

I have problem with lookup when the external file is more than two folders deep.

I have a defined name called "Book" that refers to the formula : =INDIRECT(Sheet1!$A$1).

Cell A1 =
'C:\MyPrograms\[Base Case.xls]mvdu'!$a$10:$f$150

The lookup formula is: =VLOOKUP($E11,Book,3,FALSE)


This works fine, but when I move the file to:
'C:\MyPrograms\programs\moreprograms\[Base Case.xls]mvdu'!$a$10:$f$150
I get #REF!

Is there a limit as to how many folders deep either indirect or vlookup can go?

Thanks
Don
 
Hi Don:

I don't believe there is any "folder limit". However, INDIRECT does *not*
work with closed workbooks.

Regards,

Vasant.

Hi,

I have problem with lookup when the external file is more than two folders
deep.

I have a defined name called "Book" that refers to the formula :
=INDIRECT(Sheet1!$A$1).

Cell A1 =
'C:\MyPrograms\[Base Case.xls]mvdu'!$a$10:$f$150

The lookup formula is: =VLOOKUP($E11,Book,3,FALSE)


This works fine, but when I move the file to:
'C:\MyPrograms\programs\moreprograms\[Base Case.xls]mvdu'!$a$10:$f$150
I get #REF!

Is there a limit as to how many folders deep either indirect or
vlookup can go?

Thanks
Don
 
Don Pistulka said:
I have problem with lookup when the external file is more than two
folders deep.

I have a defined name called "Book" that refers to the formula :
=INDIRECT(Sheet1!$A$1).

Cell A1 =
'C:\MyPrograms\[Base Case.xls]mvdu'!$a$10:$f$150

The lookup formula is: =VLOOKUP($E11,Book,3,FALSE)

This works fine, but when I move the file to:
'C:\MyPrograms\programs\moreprograms\[Base Case.xls]mvdu'!$a$10:$f$150
I get #REF! ....
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Click to expand...

Don't post in @#$%^&* HTML please. Plain text only. HTML can carry viruses.

It all depends on what you mean by 'move the file'. If the file is open in
Excel, Windows won't let you move it anywhere else. So to move it, it must
be closed.

What is the *complete* *AND* *exact* sequence of steps involved?
 
Back
Top