Copy columns from one workbook to another

[dvm49]

Hello Guys,

I have two excel workbooks (Loc1 and Loc2). Loc1 contains only the LocationID column whereas Loc2 contains LocationID column as well as other columns. In Loc1 workbook, I need to use vlookup and compare the LocationID between the 2 workbooks and copy rest of the columns from the Loc2 workbook to Loc1 workbook. Any help would be appreciated.

 

[Hareesh_KLD]

Hi
open both workbooks(Loc1 & Loc2), and use regular vlookup formula in Loc1.

***no data in you Loc1 file

check attached file

 

[Hareesh_KLD]

in case you open only Loc1 then use full file path in Vlookup formula

case both files open: =VLOOKUP(A2,[Loc2.xlsx]Sheet1!$A$1:$D$32,2,0)
case only Loc1 open: =VLOOKUP(A2,'C:\Users\h\Downloads\[Loc2.xlsx]Sheet1'!$A$1:$D$32,2,0)