|
|
#1
05-10-2017, 06:38 AM
|
|||
|
|||
Best formula for matching column data from one workbook into another
Hello there,
I have two separate workbooks. The data in book 1 is identical to the data in book 2, however book 2 has a column which is not in book 1. As I have some common data, ie an order number, is it possible to use a formula to pull the desired column from book 2 over to book 1? Thank you! 
|
|
#2
05-10-2017, 06:56 AM
|
||||
|
||||
|
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....
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with Macro - copying formula to last line of data based on another column | kidwispa | Excel Programming | 1 | 07-12-2015 05:01 PM |
| Formula/function to return column names for matching values | GiJoe81 | Excel | 1 | 06-27-2015 12:13 AM |
| data entered in one workbook should be updated in other relevant workbook based on the date | vedha | Excel | 0 | 04-24-2015 08:45 PM |
| formula to work from data column | masterdineen | Excel | 16 | 08-09-2012 07:52 AM |
 macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
