Match and Copy Data between to worksheets

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

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.

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

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.