Match and Move Data in 2 Spreadsheets

[Guest]

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.

 

[Guest]

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(A2,B!A:A,0)))