Excel - VLookup - Cleanup

$8-15 USD / hour

Completed

Posted

over 2 years ago

$8-15 USD / hour

I have two Excel sheets. I am using the company name field from both sheets to match using VLookup and populate an ID field. Most matching is done but there are differences in some company names which effect the accuracy. I need this cleaned up so all possible matching is complete. This means normalizing the company names on both sheets so they match exactly. There will be duplicate names occasionally and the most complete name will survive the edit process and be matched. Please provide a cost and delivery estimate in your response.

Project ID: 32796537

About the project

20 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

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:

@AnowarRatul

$0 USD in 40 days

5.0

(366 reviews)

6.7

20 freelancers are bidding on average $12 USD/hour for this job

@uumarkhalid31

Hi I am expert in excel and i have full command on vlookup or normalizing the data. contact me and lets discuss the job with perfection and accuracy regards Umar

$12 USD in 20 days

4.9

(219 reviews)

7.0

@charleslimnet

Hello I am a proficient EXCEL VLOOKUP expert in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate about this project having gone through the instructions. I have 520+ reviews on related projects and the responses are positively overwhelming. I hold an MBA (Strategic Management), Bachelors of Commerce (Finance and Accounting) & C.P.A. (Certified Public Accountant.) Regards, Charles.

$15 USD in 40 days

4.8

(85 reviews)

6.3

@konanhenry1111

2 hours = 50$ ⭐⭐⭐⭐⭐⭐I am an engineer and I read the details accurately.⭐⭐⭐⭐⭐⭐ I am ready to start now. Just if u have more details or questions u can ask me in chat. Check my projects that I have finished related to engineering in my profile. Let us discuss in chat. "

$12 USD in 40 days

5.0

(57 reviews)

5.5

@PERPETUAL0

Hello there its not take more than hour regard s ILYAS

$12 USD in 40 days

4.8

(96 reviews)

5.4

@utkarsh7238

Hello, I can clean up your 2 Excel sheets with VLookup In how much time you want it to be completed? Let's talk about your Project Waiting for your Response!!

$8 USD in 40 days

4.9

(35 reviews)

4.8

@Peefect

Hi, After checking file I have found I can do it with in 20 to 30 min only . Thanks.(Note-I am an expert and I am waiting please reply fast)

$8 USD in 40 days

4.9

(34 reviews)

4.3

@MamukaB

Good Morning I'm doing reports using excel VBA from big data bases So, it's easy job for me. I think I can do the project , but need some more detailed clarifications from you I have 15+ year experience with Excel VBA So you can trust to me. Result will be excellent Thanks

$8 USD in 40 days

5.0

(10 reviews)

3.5

@rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul

$12 USD in 40 days

5.0

(7 reviews)

2.6

@kamranbashir2020

Hi! I am a data entry expert . I am ready to start right away. Let's talk over the chat to discuss further. Thank you!

$9 USD in 40 days

5.0

(2 reviews)

1.8

@tefoai

Hi, could you please give an example? Like for example you have rows like McKinsey and Mc-Kinsey, which are same but in terms of letters they are not. And you want me to fix all of these, right? If so, I can do it for 40$ in whole dataset.

$8 USD in 40 days

5.0

(1 review)

1.3

@payalku40

HhI I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your replyyy

$12 USD in 40 days

0.0

(0 reviews)

0.0

@gracew20

Hello, I am Grace ,your data analyst professional in the following areas, with 4 years experience ≥macros ≥VBA ≥pivot tables ,power query,charts and dashboards with slicers and timeline ≥Automation of sheets with formulas ≥Data filtering, sorting, vlookups and data validation ≥statistical data analysis in excel ≥Consolidation of excel reports

$12 USD in 40 days

0.0

(0 reviews)

0.0

@Roshan876

I can arrange all your missed placed names on your sheet, on time and accurate. You won’t have anymore problems with the accuracy of your work.

$13 USD in 40 days

0.0

(0 reviews)

0.0

@MuhammadAdil17

Hello dear, Hope you are doing well Please contact that i can help you in in this issue you will not get any inaccuracy after i assist you I can do it in a few minutes. I am at your service please contact. Thanks

$10 USD in 2 days