I have a list which contains employees. Each employees has “his own” documents referenced from a document library. Is it possible that each employee gets his own library where the lookup is connected to? or can I only have one library where all documents reside and are connected with the lookup?
Due to data security I would like to avoid that all employee documents are stored in one single document library as I cannot control access to this library easily?
Sorry for the late reply. You cannot use multiple document libraries with one vLookup column, but you could give each employee a separate folder to store their documents. This folder can be set up with “item level security” to only allow the use to see his or hers documents.