If I understand your question, in column L enter , enter
=IF(x="Waiting For Return Label",1,x) and replace the "x"s with
references to the range where the tracking number or text reside.

Cliff Edwards