View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Moses Moses is offline
external usenet poster
 
Posts: 2
Default Data Query Formula

Ive been racking my brain trying to figure this out on my own but can't seem
to get it right. The problem that I have is I am trying to match phone
numbers in a column with a data base of the first 6 digits of the number that
I can call, and either get a true or fasle or any thing that will indicate
that I can call those numbers.

Example:
Number NPANXX Results
2813356789 281225 False
2813377896 281337 True
2815672345 281445 False
2813458765 False
2814452321 True

The results shoud be (False,True,False,False,True) in column C because the
number does not have the the first 6 digits