Avatar of DGWhittaker

asked on 

Excell 2013 - Vlookup of phones number issue

I am trying to perform a v-lookup on a phone number.
The table I am using to define the criteria is formatted as (XXX) XXX-XXXX
The table I am using to pull the data from is formatted as XXXXXXXXXX

I changed the format to a phone number in the same format to no avail.

Any suggestions on how I can normalize this data so the vlookup will perform as needed?

I have attached the file for review

Microsoft AccessMicrosoft Excel

Avatar of undefined
Last Comment
Professor J

8/22/2022 - Mon