I have two excel files.

File #1 has Model numbers and costs for each model number.

File #2 has the same model numbers, but incorrect costs.


I need a way to take the costs from the first file, and insert them into the second file. It needs to read the model number, take the cost, then insert that cost into the other file next to the corresponding model number.

There are thousands of items so I can't do this manually. How would I go about doing this?


Thankyou.