Data appending for our excel spreadsheet of leads

Completed Posted Sep 25, 2013 Paid on delivery
Completed Paid on delivery

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

Data Entry Excel

Project ID: #4965044

About the project

2 proposals Remote project Active Sep 25, 2013

Awarded to:

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly looking forward to work for you.

$30 USD in 0 days
(125 Reviews)
6.3

2 freelancers are bidding on average $28 for this job

datasolutionind

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

$25 USD in 1 day
(39 Reviews)
4.8