Em Andamento

Fix VLOOKUP function in excel spreadsheet

I have a spreadsheet with 4240 addresses in Australia. The data was obtained from a MySQL export. The spreadsheet contains other tabs containing the postcode for every relevant Australian locality. The address information does not include postcode so I inserted a VLOOKUP function to insert the postcode for the relevant suburb. But every cell returns “#N/A”. I need this fixed immediately. Should take less than half an hour for someone who understands the problem I expect.

This is part of a project where I have on-going work for freelancers with web scraping and ruby on rails skills so if bidders with those skills apply this is a chance for us to get to know each other.

Habilidades: Excel

Ver mais: fix vlookup excel project, contains function excel, ruby rails australia, hour australia, freelancers ruby rails, less excel, excel less, rails freelancers, ruby rails freelancers, ruby freelancers, excel vlookup, australian freelancers, mysql excel export, export excel data mysql, mysql web spreadsheet, suburb postcode, excel project vlookup, fix excel, mysql spreadsheet, mysql export excel, spreadsheet insert, project export excel, mysql vlookup, insert addresses spreadsheet, vlookup function mysql

Acerca do Empregador:
( 52 comentários ) Idalia, Australia

ID do Projeto: #5119215

Premiar a:

priyal1997

Dear Sir I'm happy to help you on this Just send me the file.. First I will do it. then you can check and offer me the job ;-)) Look forward to hearing from you soon Best regards Priyal

$20 AUD em 0 dias
(70 Avaliações)
5.7

20 freelancers estão ofertando em média $22 para este trabalho

Innovative116

Hi David. I am a excel expert and am rated best in excel project. I can fix the issue in no time but I will prefer to see the spreadsheet first. I will appreciate if you can send me the spreadsheet so I can have exact Mais

$35 AUD em 1 dia
(86 Comentários)
7.0
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$14 AUD in 0 dias
(147 Comentários)
6.5
binaryromel

Hi there, I'm exert in Advance Excel, Formula, Function and Macro. Also I'm a Web Scraping exert. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, Mais

$19 AUD in 0 dias
(51 Comentários)
5.3
javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel You project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am fully Mais

$24 AUD in 0 dias
(28 Comentários)
5.0
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Mais

$20 AUD in 3 dias
(22 Comentários)
4.2
sswijaya

Hi, Let me help you with this. I usually use index-match function which is more flexible than vlookup. Could you share the file so I can help you to fix the formula ? About web scraping, I can also do web scrapi Mais

$25 AUD em 1 dia
(19 Comentários)
4.1
vietitdotinfo

Hi. I have exp with excel and have done alot of excel projects. I am ready to do this project for you. Thanks!

$25 AUD em 1 dia
(7 Comentários)
3.6
Virtualworker50

Respected Sir, It would be pleasure for me to render my services to you for fixing vlookup formula. i have checked your csv file and know exactly what you required. I assure you the quality and timely work. I wil Mais

$12 AUD in 0 dias
(5 Comentários)
2.8
rumapaul

Hello Sir, Greetings I have knowledge in VLOOKUP.Kindly provide me some sample work now Apart from that I have knowledge in web scrapping also Waiting for your positive response Have a good day. Regar Mais

$30 AUD in 3 dias
(4 Comentários)
2.7
kaumochan

VLOOKUP works only if data is sorted. Need to work his with index and match function. Can do this for you.

$15 AUD in 0 dias
(1 Comentário)
1.0
carlandsazza

I do a lot of spreadsheet work in a full time job so fixing VLOOKUPs should be easy.. The duration is only set at 3 days in case there are any issues on the day you give the information.

$11 AUD in 3 dias
(0 Comentários)
0.0
Prabhuram1983

Hi, I think the problem might be with either data or the VLOOKUP syntax. In case its a problem with the syntax, this could be fixed right now. I would send a private message with a sample workbook. I would be onlin Mais

$20 AUD em 1 dia
(0 Comentários)
0.0
surbhichaudhary

A proposal has not yet been provided

$26 AUD in 3 dias
(0 Comentários)
0.0
dilan1234

A proposal has not yet been provided

$25 AUD in 3 dias
(0 Comentários)
0.0
tcsvnn

Hi davidforbes64, I'm a new member of freelancer, and I'm interested in your project. I have read your description and view the excel sheet. Your problem is simple and I can fix it quickly. Right now, I can discuss an Mais

$25 AUD in 0 dias
(0 Comentários)
0.0
jointsoldier

give me your excel file and you data source file to solve your VLOOKUP problem, waiting for your reply to start,

$20 AUD in 0 dias
(0 Comentários)
0.0
tariqrahim637

12-11-2013 Respected Sir, With the reference to your advertisement on the Freelancer, I wish to apply for the position "Fix VLOOKUP function in excel spreadsheet“ I am Mais

$20 AUD in 3 dias
(0 Comentários)
0.0
nipunsinghal

I can fix it right now. Please give the project. Vlookup expert here. You can trust for all your excel needs.

$20 AUD em 1 dia
(0 Comentários)
0.0
jaiganeshkasi

I will done it with in another 1 hr can you please give a chance to me. to prove myself. thanks in advance

$15 AUD in 0 dias
(0 Comentários)
0.0
dkaushi

hello sir, I never did freelance online project. but I have a 4 years experience as a data entry operator. in IIM Lanka prt lit (USA company) pleas give me a one chance. I can do this very well. THANKS

$25 AUD in 3 dias
(0 Comentários)
0.0