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?

Formulas and Functions

Chad Briddell

Copper Contributor

Mar 14, 2018

Sergei - thanks for responding. still no success.

1 - i closed both files. then opened file 1 and in the cell where i want the value returned via vlookup i have:

'=vlookup(C12,[C:\Chad\Data\2018-Std-Cost.xlsx]Sheet1!A2:E10,5,false)

then, i removed the " ' " from the front of the formula and i get an error message: "The syntax of this name isn't correct".

2 - i tried in a new cell to create the vlookup and open the second file during the process of creating the vlookup. Excel errors and states i have entered "too few arguments" and won't let me open the second file.

is there some kind of Excel/Option setting that is off?

SergeiBaklan

Diamond Contributor

Mar 14, 2018

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)

Chad Briddell
Copper Contributor
Mar 14, 2018
thanks sergei

Forum Discussion

Vlookup referencing second excel file help.