Vlookup to compare 2 workbooks - formula updates when location of workbooks changes?

Hi,

I have 2 workbooks with client data that I've used vlookup to populate from 1 into another. When I created the formula (thanks to some help), it looked like:

Please Login or Register  to view this content.

Since getting the formula to work Excel has been prompting me to update the target workbook. Now the formula adds the location:

Please Login or Register  to view this content.

If I am sending the 2 workbooks to someone else, will the formula update to reflect the new location where the target workbook is (e.g. their computer), or it will still refer back to where I stored the file? Or I need to copy and paste the data that is being pulled from the target workbook to make it easier?

I'd prefer not to show the client how my folders containing their data are set up.

Thanks!