Forum Discussion
owaisyounus
Feb 22, 2023Copper Contributor
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
City | Correction | Final |
Dallas | ||
Houston | Cypress | |
Chicago | ||
Milwaukee | New York | |
Toronto | ||
London |
- Riny_van_EekelenPlatinum Contributor
- owaisyounusCopper Contributor
Thank you so much Riny_van_Eekelen