Find Jobs
Hire Freelancers

Correct vlookup problem in excel

$12-30 SGD

Completed
Posted over 8 years ago

$12-30 SGD

Paid on delivery
Hi I have excel with vlookup. It was working good until we updated our Accpac accounting software. The Accpac software will populate data in PL worksheet. The vlookup in "PL 9 &10" worksheet will read data from PL worksheet and display under col D and Col L. Right now col D and Col L in "PL 9 &10" worksheet only shows #N/A. Need some help in troubleshooting and fixing this issue.
Project ID: 8788420

About the project

26 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I will definitely be able to fix your problem. I am a scientist by profession with qualifications in Microsoft Excel, and I create spreadsheets such as your own almost daily for complex data handling tasks. I do not believe the job will take longer than a couple of minutes. Thanks, Dan
$12 SGD in 0 day
5.0 (2 reviews)
1.6
1.6
26 freelancers are bidding on average $24 SGD for this job
User Avatar
A proposal has not yet been provided
$50 SGD in 1 day
4.9 (204 reviews)
7.2
7.2
User Avatar
send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet send me sheet
$12 SGD in 1 day
4.8 (186 reviews)
6.0
6.0
User Avatar
A proposal has not yet been provided
$19 SGD in 0 day
4.8 (76 reviews)
5.9
5.9
User Avatar
Hello, Would you share your excel file, please? I'll try to fix this problem for you. Thank you and Best regards, Hoang
$12 SGD in 1 day
5.0 (64 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$29 SGD in 0 day
5.0 (53 reviews)
5.6
5.6
User Avatar
Hello, my name is Vasile, I work a lot with advanced formulas and VBA in the reporting environment for my regular job @Oracle as global reporting analyst so anything you throw at me, if described correctly should be no problem to fix. I have created a couple of similar projects in the past, I could use the templates to speed up the process for what you need. Please let me know if you think you need me and we'll take it from there. Thanks!
$31 SGD in 1 day
5.0 (11 reviews)
3.9
3.9
User Avatar
I'm very well-verse in spreadsheets and Microsoft Excel, particularly strong in Formulas, V-Lookups, Pivoting, conditional formating, filtering and sorting.I also develop Professional Dashboards for Corporates with thier themes & SME as well. All work is delivered with high quality standards, without errors.I'm looking forward to serve you, on your available task.
$20 SGD in 1 day
4.7 (29 reviews)
4.2
4.2
User Avatar
i have experience of using vlookup formula. can you please share the file so that i can have a look at it. can u tell if the column position is changed after update? i have 15 years of experience and you can check my reviews to verify that so far i have attempted 110 projects with 100% reviews. ready to start now
$31 SGD in 0 day
5.0 (5 reviews)
3.1
3.1
User Avatar
hello there, I can help you to fix in no time. Looking to hearing from you soon. Regards ---------------------------
$18 SGD in 0 day
5.0 (4 reviews)
2.0
2.0
User Avatar
Hi, please send a message so we can discuss. and you can also send the file so that i can take a look. thanks
$21 SGD in 1 day
5.0 (4 reviews)
2.0
2.0
User Avatar
I have knowledge of MS Excel and I can assist with your vlookup function. PM for more discussions. I would require to see the files you are working with
$16 SGD in 1 day
5.0 (2 reviews)
1.7
1.7
User Avatar
From a clear view of the attached image, the fields are lost and since there is no means for you to recover the lost data, it's expected of you to re-enter the data again, I will deliver the project in two days if awarded to me. Contact me via my e-mail for a quick delivery. Thanks.
$31 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
The VLookup is one of my favorite functions, usually with the use code to locate the schedule date from which subsequently comes in a data base. When the error is indicating that not recognizing the characters in the cell is presented. I invite you to give me the opportunity to help
$31 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
My daily task is dealing with excel, vlookup, and many formulas in excel, so please give the chance and i'll prove it to you ;) you can contact me anytime and we'll discuss the method to solve this,,
$27 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I can check the excel to correct the problem you have with the formula vlookup. The correction is very fast.
$12 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Proposal belum diberikan
$29 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
well in excel formulae like Vlook up, Hlookup, IF statements,macros,pivots
$31 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$13 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir /Madam, I looked over the attached Screen Snap. I believe something went wrong with the cell references. I would solve this error in no time. Please Forward me the file so that I can review the file. Best Regards, Alosious Prince
$19 SGD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$29 SGD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
5.0
14
Payment method verified
Member since Feb 26, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.