This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I want your help in that. As you can see in the picture below I want to check these two highlighted words with the other excel sheet attached with the name of District Normalized on xName column so, the word which is matched between these two highlighted words in any cell in the xName column should be written in the new column next to the shipping address with a column title of District Name, and the cell which is empty like row 5 should take the same district name of the previous one. For example the cell in the row 11 should be filled by the same district name of row 10.
What I’m looking for is that, I want to check the shipping address with the xName that’s found in other file attached named by NormalizedDistrct. So I want to have a workflow that is checking row by row the shipping address matching with the districts names in the Xname column so the matched district name between these two files should be written in a new column next to the shipping address.
The other thing is that, I want the empty rows in the shipping address column to be filled by the previous row.