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
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
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 <[email protected]>,
el_grimley <[email protected]>
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks