If then else

[owaisyounus]

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

City	Correction	Final
Dallas
Houston	Cypress
Chicago
Milwaukee	New York
Toronto
London

[#2 · Accepted solution]

@owaisyounus 

[#3]

Thank you so much @Riny_van_Eekelen