Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
using a VLOOKUP to pull area codes out of a phone number
#1
I want to create a vlookup formula that pulls the area code out of a phone number and matches it to a table of area codes and returns an are in the country for that area code. I have tried making sure that the formatting is the same but I still get #na.
Reply
#2
Hello! It sounds an interesting idea. Where are you going to apply this program? If something does not work properly, ask someone to recheck it with fresh eyes. Are you going to create this tool for a whole country or for a certain area https://populationstat.com/united-states/seattle? Anyway, once you finalize everything, let me know where I can test how it works. It would be interesting to run this app.
Reply


Possibly Related Threads...
Thread Author Replies Views Last Post
Photo Where Is Area Code 512? granters 2 33 01-29-2020, 09:16 AM
Last Post: Logon
  The 757 won't just be the 757 any more: A second area code is coming. granters 1 29 01-25-2020, 07:45 PM
Last Post: vondesiong
  Phone Number 1-800-614-419 |Direct Bigpond Customer Support anytimesoftcare 0 80 02-26-2018, 08:53 PM
Last Post: anytimesoftcare

Forum Jump:


Users browsing this thread: 1 Guest(s)