Results 1 to 4 of 4

Thread: Match and Copy Data between to worksheets

  1. #1

    Match and Copy Data between to worksheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi There,

    I am working on two work sheets with 20k rows and I need to match and copy the information from one sheet to another. Its not a simple matter of copy and paste as the two worksheets are different.

    See the attached image

    I need to match the sku on sheet A with Sheet B then copy the cost and price to Sheet B from Sheet A?

    Can this be done as I dont fancy going through the whole sheet manually.


    Thank for your help in advance guys,

    Joe







    Click image for larger version. 

Name:	pricelist.jpg 
Views:	18 
Size:	106.8 KB 
ID:	2733

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    With both workbooks open...

    =IFERROR(INDEX('[WorkbookA.xlsx]Sheet1'!F:F,MATCH($F2,'[WorkbookA.xlsx]Sheet1'!$C:$C,0)),"")

    copied down and across.

    Replace Workbook name and sheet name and/or cell/range references as required.


  3. #3
    Any chance you could do a sample based on the image attached? Sorry but not very good with excel

    Thanks NBVC

    Workbook A = jhprice.xls
    Workbook B = websiteimport.csv

    both have sheets named Sheet1
    Last edited by hunterjo2; 2014-10-16 at 01:57 PM. Reason: additional info

  4. #4
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    All you have do is replace the workbook names then... assuming you want the formula in column H of websiteimport.csv, then in H2 enter:


    =IFERROR(INDEX('[jhprice.xls]Sheet1'!F:F,MATCH($F2,'[jhprice.xls]Sheet1'!$C:$C,0)),"")

    copy it down.


Posting Permissions

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