Yes:

Say in A1 thru B3 we have:

1 ='C:\[a.xls]Sheet1'!$C$7
2 ='C:\[a b.xls]Sheet1'!$A$14
3 ='C:\Documents and Settings\jr\My Documents\[nebula.xls]Sheet1'!$B$1


=VLOOKUP(3,A1:B3,2) will return a value from the nebula without the nebula
being open.
--
Gary''s Student - gsnu200777


"Jeremy" wrote:

Is it possible to create a VLOOKUP in an open worksheet that collects data
from a closed worksheet?