Formula non specific lookup
 

Hi,

I have in column C city county names I have in column E invoice numbers
in column K I need to place the city name.
I have sorted by invoice # in order to get every tax piece of the invoice
required.
City & county name.

The city name and the county name are not in different columns and they can
only be identified by either CO or CNTY. I'm trying to break out the
columns.

I now need to create a formula that will pull the city name over to column
K. The problem is since the city and county are in the same column and the
wording of the city county is not specific I cannot use the lookup.
ex.
"C" "E" "'J"
"k"
northport 080006 tuscaloosa CNTY need northport
to show here
northport 080006 tuscaloosa CNTY need northport
to show here
tuscaloosa cnty 080006 tuscaloosa cnty need northport
to show here
montgomery co 12345 montgomery co need montgomery here
montgomery 12345 montgomery co need montgomery here

Can you help?