Area Code Look up

[cmahon1995]

Hi all, I'm trying to figure out how to formulate cells so that when I copy paste a list of area codes, the appropriate state shows up. I.e. paste in area code 617 and MA shows up instead of 617. Any thoughts?

[FDibbins]

if your codes are on column A and the states in column B, use something like this...

=vlookup(A1,$B$1:$B$100,2,false)

[cmahon1995]

I got #N/A

[jeffreybrown]

What did you use that gave you #N/A?

What you were given may need to be expand to cover all the range.

=vlookup(A1,$B$1:$B$100,2,false)

This will look at A1 and find a match in the second column, but if you are only referencing column B then there is no second column.

[FDibbins]

you may need to extend the range, too. I just used down to row 100 as an example