Formula help please - finding a last item/status

Please can you guys help, I need help on a spreadsheet.

Column A will contain an item name, repeated as individuals e.g. Hats, Gloves, Socks, Hats, Gloves, Socks...

Column B will contain the status of each item, e.g. Shipped, Pending, On Hold, etc

Column C will contain the updated status of each item

I would like column D to compare the B and C and tell me the latest status on an item.

Is it possible to do this?

I hope I have made sense.

Hi,

Please try the following formula in D1 drag down:

=IF(C1="",B1,C1)