HELP!! adding Area codes with phone numbers and state HELP

[Alpha51]

This should be a simple question. I'm very new with Excel. and all
want to do is when I enter a phone number with area code in a cell
want to detect the area code (better said the first three numbers
enter).if the first three Number (area code) match a certain area cod
then I want it to display the corresponding STATE on the next Cell ove
to the right. I know I'll have to enter the area codes manuall
somewhere so it detects them. But I am so lost. I need to figure ou
how to do this to make my work more efficiently. That way I don't hav
to look up the area codes every time I enter a phone number. (which i
what I do for many hours of the day. Thank you


P.S. Please dummy term it for me :

 

[Peo Sjoblom]

You have to make a 2 column table with all the area codes in the left column
and their states in the right column,
possibly in another sheet and then use a formula so if you for instance type
in the phone number in A2 then maybe in B2 you can use something like this

=IF(A2="","",VLOOKUP(--LEFT(A2,3),Sheet2!$A$3:$B$1000,2,0))

where the table would be in sheet2

--

Regards,

Peo Sjoblom

This should be a simple question. I'm very new with Excel. and all I
want to do is when I enter a phone number with area code in a cell I
want to detect the area code (better said the first three numbers I
enter).if the first three Number (area code) match a certain area code
then I want it to display the corresponding STATE on the next Cell over
to the right. I know I'll have to enter the area codes manually
somewhere so it detects them. But I am so lost. I need to figure out
how to do this to make my work more efficiently. That way I don't have
to look up the area codes every time I enter a phone number. (which is
what I do for many hours of the day. Thank you


P.S. Please dummy term it for me


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[Alpha51]

Thank you