Data appending for our excel spreadsheet of leads
$10-30 USD
货到付款
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
项目ID: #4965044
关于项目
授予:
Consider it done. Check my past reviews for your reference. Eagerly looking forward to work for you.
有2名威客正在参与此工作的竞标,均价$28/小时
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