I'd try changing

=VLOOKUP(A1,"'C:\Desktop\"&A2,3,FALSE)

to

=VLOOKUP(A1,indirect("'C:\Desktop\"&A2),3,FALSE)

HTH,
Barb Reinhardt

"Dan" wrote:

I am trying (very unsuccessfully) to create a vba function that will be like
vlookup but will look in other sheets have 3 argument.
My problem is how to pass the reference to the other sheet to the function


I am aware I can do this without a function:
=VLOOKUP(A1,'C:\Desktop\[test3.xls]Sheet2'!$A$1:$C$18,3,FALSE)
But then if I try to do:
=VLOOKUP(A1,"'C:\Desktop\"&A2,3,FALSE)
A2= [test3.xls]Sheet2'!$A$1:$C$18
It does not work

Any idea?
Dan