how to make sure seperate workbooks are linked

[ASZ_Excel]

Hi All,
my excel workbooks are set up in such a way that they are not linked to each other, i.e.if I open up two workbooks and try do vlookup across the two, it does not work. could you please advise how to fix it? thank you

 

[BlueAure]

Try using a fully qualified address like this:

[Workbook_name]Sheet_name!Cell_address
or
[Sales.xlsx]Jan!B2:B5