Matching the Districts Name

[Feras95p]

Dear all, 

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.  

I hope my explanation is clear.

[Bennel_Wilson]

Hi @Feras95p ,

Although, I don't understand the language at all, I'll need the file with the shipping address column as well to help draw a workflow. Would you be able to share that as well.

Regards

Benn

[Feras95p]

Here it is 

[Feras95p]

Hi @Bennel_Wilson ,

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.

I hope now it’s clear 🙏🏻

[Bennel_Wilson · Accepted solution]

Hi @Feras95p ,

Let me know if this works. I did try some google translate to verify the output. Nevertheless, let me know if this work for your.

Regards,

Benn

P.S: In case this solves your query,kindly mark it as a solution.