Data Analysis Internship Assignment Help!

Hi guys,

I'm a beginner to Microsoft Excel and currently working on a diffuclt assignment.
Lets say I have 5 columns. One representing item number, voucher price, contract price, date and previous price. What I'm trying to do is have the previous price column to only show me the "previous price" every time the voucher price would change. Is there a way to do this?

Can you upload an example of what you're trying to accomplish?

Capture 22.PNG

Don't mind the colors.