Forum Discussion

Mheidi's avatar
Mheidi
Copper Contributor
Jun 16, 2023

How to replace name in a cell with another name according to a table?

Hello everyone. In an excel sheet, I have two columns where one of them corresponds to the names of communes and the one next to it corresponds to the districts of these communes. In another sheet, I try to ensure that in a column of a table, the name of the municipality is automatically replaced by the name of its district. How should I do it? What formula to use? Thank you in advance for your precious help.

  • Mheidi 

    Logically, how municipality is linked to district or commune? Perhaps you may share short sample file to illustrate, or at least a screenshot.

Resources