Chat/Discussion
I've tried Googling this to no avail (or maybe I'm not looking closely).
Is it possible to have another spreadsheet as the source data in a VLOOKUP? I.E. linking to the source data spreadsheet in the VLOOKUP so that the spreadsheet containing the source data hasn't got to be open for any other...