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

Thanks!
Dennis
December-2015-Manifests-151217.xlsm