Formula to autopopulate state ID.

[Sithtechnology]

I have an Excel worksheet I use to log crew members in and out. I have a field where I type site ID and the other field I type market code.

So I for Example Site ID IL12345, Market would be IL, how would I get it to auto populate based off the first two letters? I have 16 different markets.

Any help is greatly appreciated.

 

[Marcílio_Lobão]

Sithtechnology, Good morning.

Suppose:

A1 --> Site ID --> IL12345

Try to use:

B1 --> market code --> FORMULA

[B]=LEFT(A1, 2)[/B]

Is that what you want?

I hope it helps.