Use lookup table in another WB?

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
 
R

RagDyeR

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
 
Top