Use lookup table in another WB?

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi There,

I'm running Excel 2000 under windows NT. Is it possible
to reference a lookup table that is in another workbook?
I know how to access it in a different worksheet, but I
can't figure out the syntax for referencing a different
workbook. Thanks for any suggestions!

Sue
 
The easiest way to create the link is to have both books
open. In the destination cell (where you want the
formula) click "=" and then go the other book (reference
book), find the cell, click on it and press enter. Once
you close the reference book, the full path to the file,
sheet and cell will be visible in the destination cell.
Looks like this:

='C:\my files\excel\[workbook]sheet1'!$A$3

Good luck!
 
With lookup formula in Book1 and lookup table in Book2:

=VLOOKUP(A1,[Book2]Sheet1!$A$1:$B$10,2,0)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi There,

I'm running Excel 2000 under windows NT. Is it possible
to reference a lookup table that is in another workbook?
I know how to access it in a different worksheet, but I
can't figure out the syntax for referencing a different
workbook. Thanks for any suggestions!

Sue
 
Back
Top