I recommend using a table with 2 cols; col1 for area codes, col2 for
the state abbreviation. Give the table a local defined name like
"'Sheet2'!StateAreaCodes" and use it in a VLOOKUP function.

On Sheet1, give the column where area codes are entered a local defined
name that is col-absolute, row-relative. Example...

Select the first cell in the AreaCodes col.
Open the DefineName dialog and enter "'Sheet1'!AreaCode" for the
name.
Remove the $ symbol between the col lable and row number.
Example for area code col "C"
Name="'Sheet1'!AreaCode" (replace Sheet1 with actual sheetname)
RefersTo=$C1

On sheet1, in the col where you want the state abbreviation...
=VLOOKUP(AreaCode,'Sheet2'!StateAreaCodes,2,False)

...and copy this down as desired.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion