functions

[trekiejon]

Im trying to get a function that will recognize an area code and put th
correct market number in it. The only way I know how to do it, is t
use a bunch of functions to do it, which I cant do because you can onl
have 7 in one cell. let me put what Im wanting to better explain.


If(D=917 or 918 or 919...etc,"42")


please help me out, doing this for work
thanks,
Jo

 

[Gord Dibben]

Jon

Perhaps VLOOKUP with your area codes in one column and your market numbers in
an adjacent column?

Column A has area codes.
Column B has corresponding market numbers

In D1 enter =VLOOKUP(C1,$A$1:$B$10,2,FALSE)

Enter an area code number in C1.

Gord Dibben Excel MVP