Need to take my area code list, and make a state list.

Hey Martin, that file codes is amazing, but there is something strange going on..

When I replace all the area codes you had in there, with the list of my area codes, everything goes # N/A for some reason...

But if i manually type in an area code... it works.. And I am using the same font and size when im copying pasting.

Martin i uploaded my excel file im trying to do it to here: http://drop.io/hcfxmbw

You could probably do it in a few seconds.

GOT IT!

Used this: =VLOOKUP(A2,Sheet2!$A$1:$C$388,2,FALSE)

and i had to convert all my numbers from Text to Numbers...

thanks soo much!!