i assume that you have a list of all 88 counties? Have
the next column with the number that you want to
assosciate with it, then rangename the table ( both
columns) with a name like 'Counties'

Next, on your address, add a column to get the county name
eg
=LEFT(A1,FIND(" ",A1)-1)
then add this in the next column (or combine them)
=VLOOKUP(C1,Counties,2,False)
where C1 is the stripped out county


Patrick Molloy
Microsoft Excel MVP

Send me your workbook if you want me to demo it

-----Original Message-----
There are 88 total counties, which was causing
a 'formula
too long' error in some trials.

Thanks,
Chris

.