Replace string in column A based on query of multiple columns

[olivne]

Hi

I have this table:

customer | city
A        | NY
B        | NY
A        | LA

and I want to replace the value in `customer` to B only when it's  `customer == A` and `city == LA`. 
I checked this solution but it resulted in deleting all entries beside the one I replaced.
```

eval customer=if(match(customer, "A"), "LA", customer)

[ITWhisperer · Accepted solution]

So you want

customer | city
A        | NY
B        | NY
B        | LA

 If so, try this

eval customer=if(match(customer, "A") AND match(city, "LA"), "B", customer)