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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
function help! 6
a function that counts the number of cells with information 1
Getting data into control combo boxes 4
IF Function 3
Wild characters in function? 3
IF function help please? 0
Sumif Function 1

Back
Top