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

Veja mais: fix vlookup excel project, contains function excel, work in freelancers, web scraping freelancers, ruby on rails australia, no work in australia, hour in australia, freelancers ruby on rails, freelancers excel, less than excel, excel less than, rails freelancers, web scraping ruby, Vlookup, ruby on rails freelancers, ruby freelancers, freelancers web scraping, excel vlookup, australian freelancers, mysql excel export, export excel data mysql, mysql web spreadsheet, suburb postcode, excel project vlookup, fix excel

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

ID do Projeto: #5119215

Concedido a:


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 Comentários)

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


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)

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)

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)

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)

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)

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)

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)

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)

Hello Sir, Greetings I have knowledge in [login to view URL] 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)

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)

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)

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)

A proposal has not yet been provided

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

A proposal has not yet been provided

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

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)

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)

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)

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)

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)

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)