Thank you for your response.This was very helpful!


"SimonCC" wrote:

You'll need single quotes ( ' ) around the filename and sheetname when
there's a space involved in the name. So rather than just:
=VLOOKUP(A4,[test1.xls]Sheet 1!$A$4:$A$1000,1,FALSE)
you'll need:
=VLOOKUP(A4,'[test1.xls]Sheet 1'!$A$4:$A$1000,1,FALSE)

-Simon


"Churley" wrote:

I am attempting to use VLOOKUP to link 2 workbooks together.
This formula works fine:

=VLOOKUP(A4,[test1.xls]Sheet1!$A$4:$A$1000,1,FALSE),

However, when I try to copy this formula into another workbook where the
workbook name has a space in it, i.e., test 1, I get this error message: Name
invalid.
Any Suggestions??