vlookups not work when the file is closed

[sokevin]

I have 2 spreadsheets...

Spreadsheet1 - has all the source

Spreadsheet2 - has all the links to the source data



i do vlookup in spreadsheet2 referencing spreadsheet1.


when i close spreadsheet1.. all my vlookup in spreadsheet2 become
#n/a


why is this happening?

this is a rather large file.

is it coz it doesnt have enough memory to reference spreadsheet1, whe
spreadsheet1 is closed?



thanks

kevi

 

[Harlan Grove]

i do vlookup in spreadsheet2 referencing spreadsheet1.

when i close spreadsheet1.. all my vlookup in spreadsheet2 becomes
#n/a

What's the *EXACT* formula you're using?

 

[sokevin]

=IF(ISNA(VLOOKUP(B14,'G:\Kevin\[ABC Report.xls]ABC Jul03
Jun04'!$J:$M,4,FALSE)),IF(ISNA(VLOOKUP(B14,'G:\Kevin\[AB
Report.xls]ABC Oct02
Jun03'!$J$1:$M$45889,4,FALSE)),"",VLOOKUP(B14,'G:\Kevin\[AB
Report.xls]ABC Oct02
Jun03'!$J$1:$M$45889,4,FALSE)),VLOOKUP(B14,'G:\Kevin\[AB
Report.xls]ABC Jul03 - Jun04'!$J:$M,4,FALSE))


i have simplified the path of the vlookup a bit it was actually

g:\finance\...\....\....\.xls


basically the formula is supposed to vlookup the Jul03 -jun04 report
if its not found there then vlookup the oct02-jun03 repor

 

[sokevin]

p.s

i had to do a double vlookup coz notice i have about 90,000 rows o
data, so i cant fit it all into 1 worksheet

cheer