Match and Move Data in 2 Spreadsheets
 

I have 2 spreadsheets that have one column of data that is the same. I want
to match that data and bring the corresponding data from another column into
the first spreadsheet.

Match and Move Data in 2 Spreadsheets
 

One way via INDEX/MATCH ..

Assume data in sheets: A, B,
in cols A and B from row2 down
with the key col = col A
and you want to bring over data into A's col C
from B's col B that matches what's in col A

In sheet: A,

Put in C2:
=INDEX(B!B:B,MATCH(A2,B!A:A,0))
Copy down

If you want blanks: "" to be returned for any non-matching cases
use instead in C2:
=IF(ISNA(MATCH(A2,B!A:A,0)),"",INDEX(B!B:B,MATCH(A 2,B!A:A,0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve T" wrote:
I have 2 spreadsheets that have one column of data that is the same. I want
to match that data and bring the corresponding data from another column into
the first spreadsheet.