Ok....now I got passed the formula error (missing single quotes)...now the
result is "#Value!".....any ideas why? Thanks.

"deeds" wrote:

Sorry for the troubles....now I can't seem to get the formula to work...it is
giving me a "The formula contains an error..."message. I setup your exact
example...here is my formula:
=VLOOKUP(A1,pull("'"&c:\foo\[deleteme.xls]&A&"'!"&$B$2:$C$8),2)

What is the problem with this?? Thanks again.




"Harlan Grove" wrote:

deeds wrote...
. . . Now I am getting hung up on the first 2 lines of code...
Attribute VB_Name = "pull"
Option Explicit
....

Delete the Attribute line. It's generated when exporting from the VBE,
and when imported into the VBE it'd name the new module. But you're
pasting code, so it serves no purpose other than to throw syntax
errors.