Excel cell value match

I’m trying to match x value with excel column
if match found then i want to update y value in corresponding row in z column
how can i to?

Hi @pravin_bindage

Try to use For each row in Data table activity and followed by use if activity

Condition : CurrentRow("Column Name").Contains("You value to match")

If the Value Match with the X column it will go to Then part

Use Assign activity

Currentrow("Column Z name") = "Update the Y Value"


Hi @pravin_bindage

You can use find /replace to find x value in the excel and get the row index…then use it in a write cell to update the value of z column

For each keyword this can be repeated