Return a lable based on a alpha-numeric value, or first numeral.

[TPS]

Hi, I don't know if this is possible or not. I want to be able to apply a label to a client's record based on their client number. The problem is the number also contains letters as in this example 30049910MULL. Clients with numbers beginning with 300 are from VIC and clients with numbers beginning with 200 are from NSW (Australian states). Any assistance is greatly appreciated. See the sample attached.

[Pete_UK]

Try this in C2:

=IF(LEFT(B2,3)="300","VIC",IF(LEFT(B2,3)="200","NSW",""))

then copy down.

Hope this helps.

Pete

[kersplash]

You could do something like this.

Please Login or Register  to view this content.

[sandy666]

or another way:

Please Login or Register  to view this content.

many ways

[TPS]

Thx again for your help Kersplash.

[TPS]

Thx Sandy.

[TPS]

Thx Pete, much appreciated.

[sandy666]

You are welcome

have a nice day

[Pete_UK]

Glad to help, TPS - thanks for the rep.

Pete