Move value to another cell using If statement

[RichardAlt]

Hello guys,

I'm having a problem using the If statement.

This is my sample data.

I want to move the subtotal amount to "REF UL 31/03/20 TR"

My desired output something like this.

Just move the subtotal amount to "REF UL 31/03/20 TR", But I need to use Contains function because "REF UL 31/03/20 TR"  is not fixed. It changes the date.

[grazitti_sapna · Accepted solution]

Hi @RichardAlt , I hope this helps.

[RichardAlt]

Yup, it works, Thank you!