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
Thanks!
Dennis
December-2015-Manifests-151217.xlsm
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
try
=IFERROR(VLOOKUP(--SUBSTIT UTE(SUBSTI TUTE(SUBST ITUTE(SUBS TITUTE(D3, "(",""),") ","")," ",""),"-",""),Sheet1!N:Z,1 3,0),"")
=IFERROR(VLOOKUP(--SUBSTIT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect!
Thanks Jim!
Dennis
Thanks Jim!
Dennis
you are welcome. i am glad i was able to help.
pls try
=VLOOKUP(--SUBSTITUTE(SUBS
Regards