Thread: Best formula for matching column data from one workbook into another
View Single Post
 
Old 05-10-2017, 06:56 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
You can try VLOOKUP() or INDEX/MATCH

e.g. =VLOOKUP(A2,'[yourfile.xlsx]sheet1'!$A$1:$E$10,5,FALSE)

or =INDEX('[yourfile.xlsx]sheet1'!$E$1:$E$10,MATCH(A2,'[yourfile.xlsx]sheet1'!$A$1:$A$10,0))

Both will extract date from column E of yourfile.xlsx, sheet1 where column A of that file matches A2 of your active sheet....
Reply With Quote