I'm not sure I fully understand your requirement, but if both fields are on the same entity, then it might be possible to use a calculated field for this.
If the fields come from different entities, then you may need a plugin or workflow to achieve this.
If you need further information, it may be helpful to post an example of the records and values
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk