Matching product cost data across two spreadsheets

[isabellaheard]

Hi there,
Apologies if this is a little basic, but I've tried a few things and not had much luck!

I have two sheets, one has around 570 products and the other has 575, with mostly matching product codes.

One sheet has a column with the cost of each product, one doesn't. How can I quickly add the cost of products to the second sheet with the matching product codes?

What formula would I need, and where would I need to add this?

Any help would be massively appreciated!

 

[mohadin]

Hi, and welcome in here
Vlookup
Or
Index,match
Ex
product & cost in sheet1
in sheet2

B1=IFERROR(VLOOKUP(A1:$A$575,Sheet1!$A$1:$B$575,2,0),"")

or

 B1=IFERROR(INDEX(Sheet1!$A$1:$B$575,MATCH($A$1:$A$570,Sheet1!$A$1:$A$575,0),2),"")