We are a UK business with 2 worksheets,
1. Leads worksheet, which have most dialling codes set out where (01234) becomes (+44 1234) for Skype click to call. Our data also has a lot of missing "City" column information.
2. UK Area Codes Worksheet, Where the dialling codes are currently (01234) format with the column "City" filled in.
We need the UK Area Codes to be in the Skype friendly format (+44 1234) and the "City" to be appended in our lead worksheet so we are able to filter by city within our CRM.
I have supplied the full worksheet for UK Area Codes and a Sample of our Leads below for your information.
Within the Sample Data you will see where we need the City appended.
If anyone is able to perform this task then please let me know ASAP as I have spent hours on it!! I have been given the following formula to fix the issue but am unable to implement it on our data spreadsheet:
=IFERROR(IFERROR(INDEX(Codes!$B$2:$B$650,MATCH(MID(Q8,4,5)+0,Codes!$C$2:$C$650,0)),INDEX(Codes!$B$2:$B$650,MATCH(MID(Q8,4,4)+0,Codes!$C$2:
PLEASE NOTE WE WANT TO SEND YOU THE FULL LEAD WORKBOOK AND YOU RETURN THE DATA WITH THE SOLUTION IMPLEMENTED
We know that this is not a big project and need it done ASAP as we are sitting in the office waiting for it!
Lee
City State PostalCode Country Latitude Longitude Phone
Colchester CO7 8ED United Kingdom +44 1206825303
Bolton BL3 3JW United Kingdom +44 1204390737
This is the sample from first two entry