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 |
2 Replies
- Riny_van_EekelenPlatinum Contributor
- owaisyounusCopper Contributor
Thank you so much Riny_van_Eekelen