
August 10th, 2012, 09:51 AM
|
|
Registered User
|
|
Join Date: Aug 2012
Posts: 1
Time spent in forums: 1 h 13 m 13 sec
Reputation Power: 0
|
|
Copy data in row from one file to another based on matching data
Hi,
I have 2 files named confirm.xls and export.csv both files have identical data in columnA (starting at A2) but not in the same order and using columnA to match, I need the data from confirms.xls on that same row on columns C,E and F to be written over to the other file export.csv in the the same columns but in the row that they match on columnA.
Example confirm.xls
ColumnA | ColumnC | ColumnE | ColumnF
114919118-1 | FEDX | MP-001 | 1
114911422 | FEDX | MOP305 | 2
114901552 | FEDX | PB05 | 1
Example required output file export.csv
ColumnA | ColumnC | ColumnE | ColumnF
114901552 | FEDX | PB05 | 1
114919118-1 | FEDX | MP-001 | 1
114911422 | FEDX | MOP305 | 2
I have been trying IF(INDEX(confirm.xls!$A$2:$A,MATCH(export.csv!$A$2 :$A)) THEN
and I'm not sure how I would copy that row column C,E and F to to export.csv on the same row as it matched.
Any help is appreciated,
David
|