Hi,

Suppose you create a little lookup table in L1:M3:

NVA Norfolk
RVA Richmond
SNC Selma

then your formula in J1 would be

=LOOKUP(MID(C1,2,3),L$1:M$3)

If you named the range L1:M3 "T" then this would be

=LOOKUP(MID(C1,2,3),T)
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RNCKWMN" wrote:

Column C has various 8 character codes (city & state abbreviations). One #
and 7 alpha. If the 2nd, 3rd & 4th characters = "NVA" then I want it to
return "Norfolk" in a Column J... if they = "RVA" it should return "Richmond"

Column C Column J
0NVARIVA should yield Norfolk
2RVACFVA should yield Richmond
1SNCEUNC should yield Selma

What formula or function do i use to make this happen?