Feb 22 2023 03:05 PM
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 |