Change the data in one field based upon the first 5 letters of a different field

[eabonacci22]

If my Matter # begins with VWXYZ then the Location should be "Israel" instead of Great Britain. How would I write that formula?

[Qiu · Accepted solution]

@eabonacci22 
There is a String function "StartWith", maybe we can use.

[eabonacci22]

Thank you so much!  I am a rank beginner with this software and greatly appreciate the help!  Worked like a charm.

[eabonacci22]

It seems I still have a problem.  When I use the script you provided the following happens:

What I need is the following:

How should I revise the script such that the location doesn't change except when the Matter # begins with "VWXYX"?

I appreciate the help!

[atcodedog05]

Hi @eabonacci22 

Can you share this data in excel file.

[atcodedog05]

Hi @eabonacci22 

It would be something like this

Hope this helps : )