How can I adjust prices in a CSV file using Excel lists?

Hello, I have to adjust my prices in a CSV file. I have the new prices in 2 Excel lists. In the 2 Excel lists there are 2 columns, once the SKU and once the price. As soon as you have a match of the respective SKUs, the price must be taken from the new price lists and replaced in the CSV. If there is no match, the SKU should be colored red in the CSV. It is important that only the last 5 digits of the SKU are referenced (or searched for). Is there anyone here who can do this for me today?