+ Reply to Thread
Results 1 to 2 of 2

Importing row data from one file to another based on matching data

  1. #1
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2003
    Posts
    304

    Importing row data from one file to another based on matching data

    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
    Last edited by djfscouse; 08-09-2012 at 04:35 PM. Reason: Trying to improve explanation for soliciting help

  2. #2
    Forum Contributor
    Join Date
    07-31-2012
    Location
    Los Angeles, USA
    MS-Off Ver
    Excel 2003
    Posts
    304

    Re: Importing row data from one file to another based on matching data

    Please could this be bumped to the top, thanks.
    Last edited by djfscouse; 08-13-2012 at 09:36 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1