Forum Discussion

owaisyounus's avatar
owaisyounus
Copper Contributor
Feb 22, 2023

If then else

I have two columns. Column A is a city and B is a corrected field when A has an incorrect city name. I have created a third column as final where if there's a value in the "correction field" then pick that city otherwise take the value from column A. Can anyone help with the formula? Thanks

 

CityCorrectionFinal 
Dallas  
HoustonCypress 
Chicago   
MilwaukeeNew York 
Toronto  
London  

Share

Resources