Updating cell values

Question

I need to replace Column1 value-based on specific combination of values in column 1 and column 2. Why the following formula is not working.

if [Transfer Work Basket]='FR Main-REC' and [Claim Reason]= 'Lost' then [Claim Reason] = 'Lost Recoverable' else [Claim Reason] endif

alexnajm · Accepted Answer

I think you just need to remove a portion of it

if [Transfer Work Basket]='FR Main-REC' and [Claim Reason]= 'Lost' then [Claim Reason] = 'Lost Recoverable' else [Claim Reason] endif

nagakavyasri · Accepted Answer

@jeetamar11 guess this is what you are looking for: