functions

  • Thread starter Thread starter trekiejon
  • Start date Start date
T

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:D=917 or 918 or 919...etc,"42")


please help me out, doing this for work
thanks,
Jo
 
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
 
Back
Top