vlookup from a co-authored document to a document on a server

I have recently shared an excel document via Co-Authoring, although access is great, I have some Users that vlookup to documents saved on our server or desktop - is this possible?