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?
10 Replies
=VLOOKUP(CC,DD,1,FALSE)
where CC = Value you would like to look up in the current sheet.. eg A4 or B3
DD = the selection you need to make in the second workbook against which you wish to lookup the value. eg.. [Book1]Sheet1!$A$2:$A$7
Instead of typing the name of the workbook and sheet simply select the criteria with the mouse.
1 = this is usually the column number of the selection criteria that hosts the value you wish to display in case a match is found, therefore it can be 2, 3.. totally depends upon the selection you make.
False = lookup the exact match
Chad Briddell wrote:
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?
Rohan, thanks. however....oddly...when i have both spreadsheet file 1 and 2 open and i am in file 1 creating the vlookup and i mouse to file 2, the formula does NOT populate with the name of the second file. i tried to insert the following....but did not work.
=vlookup(C12,[2018-Std-Cost.xlsx]Sheet1!A2:D10,2,false)
Chad, close the second file (or both, when re-open), file path will be added to link automatically.
