Changing text from one column to another

Hi alexaskmo,

use below formula to achieve result as per image 2

=IF(ISERROR(SEARCH("Expedition",A1,1)),IF(ISERROR(SEARCH("Genomfört",A1,1)),A1,"Genomfört"),"Expedition")