how use vlookup in excel vba

Hi
How do I use vlookup in excel vba when I want to reference another file? I can do it in the same file

Wing chan

同時打開另一file,  同平時做法一樣

TOP

唔需要打開另一file都可以

TOP