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