Forum Discussion
Vlookup referencing second excel file help.
i need to vlookup data found in a second excel file - spreadsheete 2. i am struggling to find the syntax to add to the vlookup formula in spreadsheet 1. can you advise?
That's perhaps you add sheet name manually. It shall be like this
Both files are opened
=VLOOKUP(D13,[Example5.xlsx]Sheet1!$A$1:$B$4,2,FALSE)
second file is closed, full link autogenerated
=VLOOKUP(D13,'G:\MyFolder\[Example5.xlsx]Sheet1'!$A$1:$B$4,2,FALSE)
thanks sergei