vlookup doesn't work

[mlhoward69]

I am unable to do a vlookup between different workbooks. I does however work
within the same workbook. Is their something I need to do to turn this
functionality on.

 

[L. Howard Kittle]

It should work even if the other workbook is not open.

Your formula should look something like this if you used the other workbook
to form the formula;

=VLOOKUP(A1,[Book3]Sheet1!$A$1:$B$3,2,0)

and something like this if you closed the other workbook;

=VLOOKUP(A1,'C:\Documents and Settings\L. Howard Kittle\My
Documents\Howard\[Book3.xls]Sheet1'!$A$1:$B$3,2,0)

HTH
Regards,
Howard