I'm using VLOOKUP to lookup values in a "master" spreadsheet. Previously, I would just copy the sheet into the current file from the "master" file, but I want to just reference the master file. So the Table_array in the formula needs to look at an external file|sheet|named range. Can that be done in a VLOOKUP formula, and if so, what is the format for that? An example of what I'm trying that is returning an "Invalid" response is:




=VLOOKUP(C2,[H:\Produts.xlsx]Sheet1!lookup,2,false)


where H:\Produts.xlsx is the lookup file (on a network drive)


and Sheet1! is the sheet within that file


and lookup is the named range within that sheet


The above formula produces an "Invalid" response.
Is it possible to do what I want?


Thank you