Of course you can, but please don't add confidentional information in it.

Maybe an anwer to your first question
I believe, the workbooks have to be open, if you use VLookup in another workbook.
Are both workbooks open?