We have 2 site collections in our company that we have added a primary key to both lists. Is it possible to vLookup to the other site, or is the vLookup solution for relative URLs on the same site collection only?
I don’t think this will work, but I’m actually not 100% sure. If your two site collections are in the same domain it *might* work. You will have to test it.