Hi,
I have a file named confirm.xls with six columns A,B,C,D,E,F and I have a file named export.csv with an equal amount of columns. Both files have identical data in column A (starting at A2) which if that column matches 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 column A.
Example confirm.xls
ColumnA ColumnC ColumnE ColumnF
114919118-1 FEDX MP-001 1
114911422 FEDX MOP305 2
114901552 FEDX PB05 1
Example 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.
Thanks for any help,
David
Bookmarks