Refrencing an entire worksheet?
 

Is it possible to refrence an entire worksheet from another workbook
(which is unopened) so that I can use its cells for a Vlookup?

Thanks

Graham


--
el_grimley
------------------------------------------------------------------------
el_grimley's Profile: http://www.excelforum.com/member.php...o&userid=25924
View this thread: http://www.excelforum.com/showthread...hreadid=401954

One way:

=VLOOKUP(A1,[Workbook2]Sheet1!$A:$IV,123,FALSE)

It's easiest to create the link with the workbook open, as shown above.
Otherwise, include the path in your reference.

In article ,
el_grimley
wrote:

Is it possible to refrence an entire worksheet from another workbook
(which is unopened) so that I can use its cells for a Vlookup?

Thanks

Graham

It's easier if you open the other workbook first and use the mouse to select

=VLOOKUP(D1,[myfile.xls]Sheet1!$1:$65536,3,0)

then excel will add the necessary path when you close the workbook

=VLOOKUP(D1,'C:\Documents and Settings\My Name\My
Documents\[myfile.xls]Sheet1'!$1:$65536,3,0)

otherwise you have to build the path yourself



--
Regards,

Peo Sjoblom

(No private emails please)


"el_grimley" wrote
in message ...

Is it possible to refrence an entire worksheet from another workbook
(which is unopened) so that I can use its cells for a Vlookup?

Thanks

Graham


--
el_grimley
------------------------------------------------------------------------
el_grimley's Profile:
http://www.excelforum.com/member.php...o&userid=25924
View this thread: http://www.excelforum.com/showthread...hreadid=401954